To extract the first letter from the last in the text string, please use Right Function.
=RIGHT(A1,1)
To extract the second letter from the last in the text string, please use the formula below:
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),1)
Example:
To extract the second last letter from text string "How to Extract the Second Last Letter".
The result returns the second letter "e".
Explanations:
Step 1: To find the length of the text string
| Formula | =LEN(A1) |
|---|---|
| Result | 37 |
Step 2: Extract the text from the string without the last letter
| Formula | =LEFT(A1,LEN(A1)-1) |
|---|---|
| Result | How to Extract the Second Last Lette |
Step 3: Extract the second letter from the last (or the last letter from step 2)
| Formula | =RIGHT(LEFT(A1,LEN(A1)-1),1) |
|---|---|
| Result | e |