To extract two letters away from the last letter in the text string, you need to use Right Function.

**Formula:**

Copy the formula and replace "A1" with the cell name that contains the text you would like to extract.

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

**Example:**

To extract the two letters away from the last letter from text string "**How to extract two letters away from the last letter**".

The result returns the second letter "**te**".

**Explanations:**

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

Formula | =LEN(A1) |
---|---|

Result | 52 |

**Step 2:** Extract the text from the string without the last letter

Formula | =LEFT(A1,LEN(A1)-1) |
---|---|

Result | How to extract two letters away from the last lette |

**Step 3:** Extract two letters away from the last (or the last two letters from step 2)

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

Result | te |