Excel Formulas to Extract a Last Two Words From a Cell ~ Quickly!!
Tags: excelformula, excelformulas
Published: 2021-06-18 10:42:04

---
title: Excel Formulas to Extract a Last Two Words From a Cell ~ Quickly!!
published: true
date: 2021-06-08 07:45:55 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-extract-a-last-two-words-from-a-cell/
---

Assume that you have a list of values, and you need to separate the last two words from each cell. How could you solve this problem in Excel? In this chapter, we will show the simple tricks to **extract the last two words from a cell in Excel**. Let’s see them below!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Extract last two words from the cell](https://geekexcel.com/wp-content/uploads/2021/06/Extract-last-two-words-from-the-cell.png)](https://geekexcel.com/excel-formulas-to-extract-a-last-two-words-from-a-cell/extract-last-two-words-from-the-cell/#main)<figcaption id="caption-attachment-46207">Extract the last two words from the cell</figcaption>
## General Formula:

- You can use the below formula to extract the last two words from a cell in Excel.

**=[MID](https://geekexcel.com/how-to-use-mid-function-in-microsoft-excel-365/)(A1,[FIND](https://geekexcel.com/how-to-use-find-function-in-microsoft-excel-365/)(“@”,[SUBSTITUTE](https://geekexcel.com/how-to-use-substitute-function-in-microsoft-excel-2013/)(A1,” “,”@”,[LEN](https://geekexcel.com/how-to-use-len-function-in-microsoft-excel-365/)(A1)-LEN(SUBSTITUTE(A1,” “,””))-1))+1,100)**

## Syntax Explanations:

- **MID** – This function helps to extract the number (starting from the left side) or characters from the given string. Read more on the [**MID function**](https://geekexcel.com/how-to-use-mid-function-in-microsoft-excel-365/).
- **FIND** – The Excel, **[FIND function](https://geekexcel.com/how-to-use-find-function-in-microsoft-excel-365/)** is used to find out the one text string inside the other.
- **LEN**  – In Excel, the **[LEN function](https://geekexcel.com/how-to-use-len-function-in-microsoft-excel-365/)** is used to find the length of the text string.
- **SUBSTITUTE**  – This function helps to replace existing text with new text in a text string when you want to replace text based on its content, not position. Read more on the [**SUBSTITUTE function**](https://geekexcel.com/how-to-use-substitute-function-in-microsoft-excel-2013/).
- **A1** – It represents the input value.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.
- **Minus Operator (-)** – This symbol will help to subtract any two values.
- **Plus operator (+)** – This symbol is used to add the values.

## Practical Example:

Let’s consider the below example.

- First, we will enter the input text strings in **Column B**.
- Here, we have to extract the last two words from each and every cell.

![Input Range](https://geekexcel.com/wp-content/uploads/2021/06/Input-Range-8.png)<figcaption id="caption-attachment-46213">Input Range</figcaption>

- Select any cell and type the above-given formula.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/06/Enter-the-formula-24.png)<figcaption id="caption-attachment-46210">Enter the formula</figcaption>

- Finally, press the ** ENTER**  key, you can get the result as shown below.

![Result](https://geekexcel.com/wp-content/uploads/2021/06/Result-21.png)<figcaption id="caption-attachment-46209">Result</figcaption>

## Wrap-Up:

Hope you like this article on **how to extract the last two words from the cell in Excel**. Please feel free to state your **query** or **feedback** for the above article.

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Also:

- **[Excel Formulas to Insert Double Quotes Inside the Output Cell!!](https://geekexcel.com/excel-formulas-to-insert-double-quotes-inside-the-cell/)**
- **[How to Count missing values in a list in Excel Office 365?](https://geekexcel.com/how-to-count-missing-values-in-a-list-in-excel-office-365/)**
- **[Formulas for Counting Non-Contiguous Range in Excel Using COUNTIF!!](https://geekexcel.com/formulas-for-counting-non-contiguous-range-in-excel-using-countif/)**
- **[Excel Formulas to Extract the Month Number from Name!!](https://geekexcel.com/excel-formulas-to-extract-month-number-from-name/)**