How to Extract the Two Letters from the Second Letter

To extract the two letters from the second 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.

=LEFT(RIGHT(A1,LEN(A1)-1),2)

Example:

To extract the two letters from the second letter from text string "How to Extract the Two Letters from the Second Letter".

The result returns the second letter "ow".

Explanations:

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

Formula=LEN(A1)
Result53

Step 2: Extract the text from the second letter

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

Step 3: Extract the two letters from the second letter (or the first two letters from the text string in step 2)

Formula=LEFT(RIGHT(A1,LEN(A1)-1),2)
Resultow

Leave a Reply