How do I get the last character of a string using an Excel function?

Question

How do I get the last character of a string using an Excel function?

Answer 1

No need to apologize for asking a question! Try using the RIGHT function. It returns the last n characters of a string.

=RIGHT(A1, 1)