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) |
|---|---|
| Result | 56 |
Step 2: Extract the text from the string without the last 4 letters
| Formula | =LEFT(A1,LEN(A1)-4) |
|---|---|
| Result | How 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) |
|---|---|
| Result | Le |