How to Extract N Letters away from the Nth Last Letter

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

• Extract Two Letters from the Last Letter
• Extract Two 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, and change N to the number you need.

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

Example:

To extract the 6 letters away from the 5th last letter from text string "How to Extract N Letters away from the Nth Last Letter".

The result returns the six-letter "Last L".

Explanations:

Step 1: To find the length of the text string

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

Step 3: Extract six letters away from the 5th last (or the last six letters from step 2)