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

string excel worksheet-function
shlawson picture shlawson · Dec 6, 2010 · Viewed 105.5k times · Source

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

Answer

Phil Hunt picture Phil Hunt · Dec 6, 2010

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)

Related questions

String manipulation with Excel - how to remove part of a string if another part is there?

I've done some Googling, and can't find anything, though maybe I'm just looking in the wrong places. I'm also not very adept at VBA, but I'm sure I can figure it out with the right pointers :) I have a string …

Read More
Insert characters into string in different locations

I have a string which looks like this 20141007023617. And I would like to make it look like this 2014-10-07T02:36:17Z. The T and Z are very important for me. So I would like to insert them as well. …

Read More
How to turn a string formula into a "real" formula

I have 0,4*A1 in a cell (as a string). How can convert this "string formula" into a real formula and calculate its value, in another cell?

Read More