To extract the first letter from the last in the text string, please use Right Function.
To extract the second letter from the last in the text string, please use the formula below:
Copy the formula and replace "A1" with the cell name that contains the text you would like to extract.
To extract the second last letter from text string "How to Extract the Second Last Letter".
The result returns the second letter "e".
Step 1: To find the length of the text string
Step 2: Extract the text from the string without the last letter
|Result||How to Extract the Second Last Lette|
Step 3: Extract the second letter from the last (or the last letter from step 2)