Site icon ExcelNotes

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.

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

Formula=LEN(A1)
Result52

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

Formula=LEFT(A1,LEN(A1)-1)
ResultHow to extract two letters away from the last lette

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

Formula=RIGHT(LEFT(A1,LEN(A1)-1),2)
Resultte
Exit mobile version