Excel Formulas to Extract the Nth Word from a Text String!!
Tags: excelformula, excelformulas
Published: 2020-10-12 12:01:51

---
title: Excel Formulas to Extract the Nth Word from a Text String!!
published: true
date: 2020-10-12 08:21:05 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-extract-the-nth-word-from-a-text-string/
---

## Formulas to Extract the Nth word from a Text String in Excel:

In this article, we will guide you to know the **formula to extract the Nth word from a text string in Excel 365**. 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)
## Formulas Syntax:

- For Extracting the Nth word from a Text String in the Cells, use the below formula.

**=[IFERROR](https://geekexcel.com/use-iferror-function-in-microsoft-excel-365-easy-tutorial/)([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/)(TRIM(A2),” “,[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/)(TRIM(A2)))),(C2-1)\*LEN(TRIM(A2))=1,LEN(TRIM(A2)))),” “)**

### Example:

- In the below screenshot, we give the input range in **column A** , and the Nth word in **column C**.
- After applying the formula, we can get the result as shown in the below image.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/07/ku4.png)

## Explanations for the Syntax:

- **IFERROR** – Excel IFERROR Function is mainly used to return the logical results such as **TRUE** and **FALSE**. Read more on the [IFERROR Function](https://geekexcel.com/use-iferror-function-in-microsoft-excel-365-easy-tutorial/).
- **TRIM** – The main purpose of the TRIM function is to remove the extra spaces from the text. For more details about the [TRIM Function](https://geekexcel.com/use-trim-function-in-microsoft-excel-2013-simple-methods/).
- **MID** – It helps to extract the numbers or characters from the given string. Read more on [MID Function](https://geekexcel.com/how-to-use-mid-function-in-microsoft-excel-365/).
- **SUBSTITUTE** – This function can replace existing text with a new string in a text string. Read more on the [SUBSTITUTE Function](https://geekexcel.com/how-to-use-substitute-function-in-microsoft-excel-2013/).
- **REPT** – The Excel [REPT function](https://geekexcel.com/how-to-use-rept-function-in-microsoft-excel-2013/) is Mainly used to repeat characters a given number of times.
- **LEN ** – This function can return the length of the given text string as the number of characters and also count the characters. Read more on [LEN Function](https://geekexcel.com/how-to-use-len-function-in-microsoft-excel-365/).

## Conclusion:

This article gives clarification about the **formulas to extract the Nth word from a text string in an Excel Office 365**. If you have any quarries, drop it in a **comment** box. Thanks for visiting **[Geek Excel!!](https://geekexcel.com/)** Keep Learning with us!!