Excel Formulas to Extract the Word that Contains Specific Text ~ Easily!!
Tags: excelformula, excelformulas
Published: 2021-06-19 03:09:19

---
title: Excel Formulas to Extract the Word that Contains Specific Text ~ Easily!!
published: true
date: 2021-06-10 08:32:34 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-extract-the-word-that-contains-specific-text/
---

For instance, you have a list of text strings that are mixed with any numbers, special characters, and so on. Now you need to separate the word that contains certain text or symbol. How could you solve this problem quickly? Here we will show the formulas to **extract the word that contains specific text in Excel**. Let’s jump into this article!! 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 a word that contains specific text](https://geekexcel.com/wp-content/uploads/2021/06/Extract-word-that-contains-specific-text.png)](https://geekexcel.com/excel-formulas-to-extract-the-word-that-contains-specific-text/extract-word-that-contains-specific-text/#main)<figcaption id="caption-attachment-46276">Extract a word that contains specific text</figcaption>
## Generic Formula:

- If you want to extract the word that contains specific text in Excel, you can use the below formula.

**=[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/)(” “,99)),[MAX](https://geekexcel.com/how-to-use-excel-max-function-in-office-365-with-examples/)(1,[FIND](https://geekexcel.com/how-to-use-find-function-in-microsoft-excel-365/)(“@”,SUBSTITUTE(A1,” “,REPT(” “,99)))-50),99)) **

## 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/).
- **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/)**.
- **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/).
- **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.
- **MAX** – This function helps to return the largest numeric value from the range of input values. Read more on the [**MAX function**](https://geekexcel.com/how-to-use-excel-max-function-in-office-365-with-examples/).
- **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.
- **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:

Refer to the below example image.

- First, we will enter the input text strings in **Column B**.
- Now we have to extract the word that contains specific text from the input range.

![Input Range](https://geekexcel.com/wp-content/uploads/2021/06/Input-Range-9.png)<figcaption id="caption-attachment-46277">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-29.png)<figcaption id="caption-attachment-46275">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-25.png)<figcaption id="caption-attachment-46278">Result</figcaption>

## Bottom-Line:

Here we have discussed how to **extract the word that contains specific text 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 Also:

- **[Formula to Find Position of Nth Occurrence of a Character in Text String!!](https://geekexcel.com/formula-to-find-position-of-nth-occurrence-of-a-character-in-text-string/)**
- **[Excel Formulas to Count specific word in a range ~ Easy Tutorial!!](https://geekexcel.com/excel-formulas-to-count-specific-words-in-a-range/)**
- **[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 Extract the Month Number from Name!!](https://geekexcel.com/excel-formulas-to-extract-month-number-from-name/)**