How to Extract N Letters from the Nth Letter

To extract N letters from 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, change N to the number you want.

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

Example:

To extract the six letters from the fifth letter from text string "How to Extract N Letters from the Nth Letter".

The result returns the second letter "to Ext".

Explanations:

Step 1: To find the length of the text string

Formula=LEN(A1)
Result44

Step 2: Extract the text from the fifth letter

Formula=RIGHT(A1,LEN(A1)-5+1)
Resultto Extract N Letters from the Nth Letter

Step 3: Extract the six letters from the fifth letter (or the first six letters from step 2)

Formula=LEFT(RIGHT(A1,LEN(A1)-5+1),6)
Resultto Ext

Leave a Reply