How to Extract the Second Letter from Left

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)
Result42

Step 2: Extract the text from the second letter

Formula=RIGHT(A1,LEN(A1)-1)
Resultow to Extract the Second Letter from Left

Step 3: Extract the second letter

Formula=LEFT(RIGHT(A1,LEN(A1)-1),1)
Resulto

Leave a Reply