To extract the first letter from the left, please use Left Function.
=LEFT(A1,1)
To extract the second letter from the left, please use the formula below:
Formula:
Copy the formula and replace "A1" with the cell name that contains the text you would like to extract.
=LEFT(RIGHT(A1,LEN(A1)-1),1)
Example:
To extract the second letter from the text string "How to Extract the Second Letter from Left".
The result returns the second letter "o".
Explanations:
Step 1: To find the length of the text string;
| Formula | =LEN(A1) |
|---|---|
| Result | 42 |
Step 2: Extract the text from the second letter
| Formula | =RIGHT(A1,LEN(A1)-1) |
|---|---|
| Result | ow to Extract the Second Letter from Left |
Step 3: Extract the second letter
| Formula | =LEFT(RIGHT(A1,LEN(A1)-1),1) |
|---|---|
| Result | o |
