Site icon ExcelNotes

How to Extract Two Letters away from the Nth Last Letter

To extract two letters away from the Nth 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, and change N to the number you need.

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

Example:

To extract the two letters away from the 4th the last letter from text string "How to Extract Two Letters away from the Nth Last Letter".

The result returns the second letter "le".

Explanations:

Step 1: To find the length of the text string

Formula=LEN(A1)
Result56

Step 2: Extract the text from the string without the last 4 letters

Formula=LEFT(A1,LEN(A1)-4)
ResultHow to Extract Two Letters away from the Nth Last Le

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

Formula=RIGHT(LEFT(A1,LEN(A1)-4),2)
ResultLe
Exit mobile version