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

Question

User · Answer

RIGHT A1      is quite sufficient  where the string is contained in A1      Similar in nature to LEFT  Excel s RIGHT function extracts a substring from a string starting from the right-most character        SYNTAX  RIGHT  text   number of characters          Parameters or Arguments      text        The string that you wish to extract from         number of characters        Optional  It indicates the number of characters that you wish to extract starting from the right-most character  If this parameter is omitted  only 1 character is returned       Applies To      Excel 2016  Excel 2013  Excel 2011 for Mac  Excel 2010  Excel 2007  Excel 2003  Excel XP  Excel 2000     Since number of characters is optional and defaults to 1 it is not required in this case     However  there have been many issues with trailing spaces and if this is a risk for the last visible character  in general       RIGHT TRIM A1       might be preferred

User · Answer

Looks like the answer above was a little incomplete try the following -   RIGHT A2  LEN A2 - LEN A2 -1      Obviously  this is for cell A2     What this does is uses a combination of Right and Len - Len is the length of a string and in this case  we want to remove all but one from that    clearly  if you wanted the last two characters you d change the -1 to -2 etc etc etc     After the length has been determined and the portion of that which is required - then the Right command will display the information you need   This works well combined with an IF statement - I use this to find out if the last character of a string of text is a specific character and remove it if it is  See  the example below for stripping out commas from the end of a text string      IF RIGHT A2  LEN A2 - LEN A2 -1        LEFT A2  LEN A2 -1   A2

User · Answer

Just another way to do this    MID A1  LEN A1   1

User · Answer

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

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

Examples related to string

Examples related to excel

Examples related to worksheet-function