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) |
|---|---|
| Result | 52 |
Step 2: Extract the text from the string without the last letter
| Formula | =LEFT(A1,LEN(A1)-1) |
|---|---|
| Result | How 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) |
|---|---|
| Result | te |