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) |
|---|---|
| Result | 44 |
Step 2: Extract the text from the fifth letter
| Formula | =RIGHT(A1,LEN(A1)-5+1) |
|---|---|
| Result | to 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) |
|---|---|
| Result | to Ext |