How to Extract Two Letters from the Last Letter in Excel

To extract two letters away from the last letter in the text string, you need to use Right Function.

• Extract Two Letters away from the Nth Last Letter
• Extract N Letters away from the Nth Last Letter

Formula:

Copy the formula and replace "A1" with the cell name that contains the text you would like to extract.

=RIGHT(LEFT(A1,LEN(A1)-1),2)

Example:

To extract the two letters away from the last letter from text string "How to extract two letters away from the last letter".

The result returns the second letter "te".

Explanations:

Step 1: To find the length of the text string

Step 2: Extract the text from the string without the last letter

Step 3: Extract two letters away from the last (or the last two letters from step 2)