Excel Formulas to Extract Nth Word From a Text String ~ Simple Tips!!
Tags: excelformula, excelformulas
Published: 2021-06-18 11:12:51

---
title: Excel Formulas to Extract Nth Word From a Text String ~ Simple Tips!!
published: true
date: 2021-06-08 10:37:26 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-extract-nth-word-from-a-text-string-simple-tips/
---

Have you ever suffered from the problem that you need to extract a certain word from the text string in a worksheet? Are there any good ways to deal with this problem quickly in Excel? Here, we are going to **extract the N<sup>th</sup> word from a text string 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 Nth word from a cell](https://geekexcel.com/wp-content/uploads/2021/06/Extract-Nth-word-from-a-cell.png)](https://geekexcel.com/excel-formulas-to-extract-nth-word-from-a-text-string-simple-tips/extract-nth-word-from-a-cell/#main)<figcaption id="caption-attachment-46232">Extract Nth word from a cell</figcaption>

## General Formula:

- Use the below formula to extract the N<sup>th </sup>word from a text string in Excel.

**=[TRIM](https://geekexcel.com/use-trim-function-in-microsoft-excel-2013-simple-methods/)([MID](https://geekexcel.com/how-to-use-mid-function-in-microsoft-excel-365/)([SUBSTITUTE](https://geekexcel.com/how-to-use-substitute-function-in-microsoft-excel-2013/)(A1,” “,[REPT](https://geekexcel.com/how-to-use-rept-function-in-microsoft-excel-2013/)(” “,[LEN](https://geekexcel.com/how-to-use-len-function-in-microsoft-excel-365/)(A1))), (N-1)\*LEN(A1)+1, LEN(A1)))**

## Syntax Explanations:

- **TRIM** – It helps to remove the extra spaces from the text and there is no space at the start or end of the text string. Read more on the [**TRIM function**](https://geekexcel.com/use-trim-function-in-microsoft-excel-2013-simple-methods/).
- **REPT** – In Excel, the **[REPT function](https://geekexcel.com/how-to-use-rept-function-in-microsoft-excel-2013/)** is used to repeat characters a given number of times.
- **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/).
- **N** – It specifies the N<sup>th</sup> number of text.
- **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.
- **Multiplication (\*) **– In this symbol will multiply any two values or numbers.
- **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 N<sup>th </sup>words from a text string.

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

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

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/06/Enter-the-formula-26.png)<figcaption id="caption-attachment-46231">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-22.png)<figcaption id="caption-attachment-46230">Result</figcaption>

## Bottom-Line:

From this article, you can get some clarification on **how to extract the**  **N<sup>th</sup> words from a text string in Excel**. Leave a **comment** or **reply** below to let me know what you think!

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 Ahead:

- **[Excel Formulas to Extract Multiple Lines From a Cell ~ Easy Tricks!!](https://geekexcel.com/excel-formulas-to-extract-multiple-lines-from-a-cell-easy-tricks/)**
- **[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/)**
- **[Excel Formulas to Insert Double Quotes Inside the Output Cell!!](https://geekexcel.com/excel-formulas-to-insert-double-quotes-inside-the-cell/)**
- **[Excel Formulas to Extract the Month Number from Name!!](https://geekexcel.com/excel-formulas-to-extract-month-number-from-name/)**