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 |
This is EXACTLY what I sought, with one adjustment in order to find the 5th- through 2nd-to-last characters in a cell: change the final "1" of the formula to a "4".
I NEVER would have got this done so efficiently on my own; I have never used the LEN function before.
Thank you VERY much!