How to Extract the Nth Letter from Left

To extract the Nth letter in the text string, you need to use Left Function.

Formula:

Copy the formula and replace "A1" with the cell name that contains the text you would like to extract, and replace N with the number you want.

=LEFT(RIGHT(A1,LEN(A1)-n+1),1)

Example:

To extract the third letter from the text string "How to Extract the Nth Letter from Left".

The result returns the third letter "w".

Explanations:

Step 1: To find the length of the text string;

Formula=LEN(A1)
Result39

Step 2: Extract the text from the third letter

Formula=RIGHT(A1,LEN(A1)-3+1)
Resultw to Extract the Nth Letter from Left

Step 3: Extract the third letter (or the first letter from step 2)

Formula=LEFT(RIGHT(A1,LEN(A1)-3+1),1)
Resultw

Leave a Reply