To extract Nth last letter in the text string, you need to use Right Function.
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.
To extract the sixth letter from text string "How to Extract the Nth Last Letter".
The result returns the six-letter "L".
Step 1: To find the length of the text string
Step 2: Extract the text from the string without the last 5 letters
|Result||How to Extract the Nth Last L|
Step 3: Extract sixth letter from the last (or the last letter from step 2)