Extract the Word that Contains a Specific Character in Excel!!
Tags: excelpreface, excelbasics, exceltutorials, extractwordcontainss
Published: 2021-01-27 11:41:25

---
title: Extract the Word that Contains a Specific Character in Excel!!
published: true
date: 2021-01-27 11:37:47 UTC
tags: ExcelPreface,ExcelBasics,ExcelTutorials,Extractwordcontainss
canonical_url: https://geekexcel.com/extract-word-that-contains-a-specific-character-in-excel/
---

Sometimes, you need to find the word from a cell that contains a specific character such as @, comma, slash, etc. To solve this problem, you may need some quick tricks. Here we will explain **how to extract the word that contains a specific character in Excel**. Let’s get 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)

## Formulas and Syntax Explanations:

- Use the below formula to get the word that containing a specific character 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/)(B1,” “,[REPT](https://geekexcel.com/how-to-use-rept-function-in-microsoft-excel-2013/)(” “,255)),[FIND](https://geekexcel.com/how-to-use-find-function-in-microsoft-excel-365/)(“symbol”,SUBSTITUTE(B1,” “,REPT(” “,255)))-100,255))**

### Function Explanations:

- [**TRIM Function**](https://geekexcel.com/use-trim-function-in-microsoft-excel-2013-simple-methods/) – This function will help to remove the extra spaces from the text and there is no space at the start or end of the text string.
- [**MID Function**](https://geekexcel.com/how-to-use-mid-function-in-microsoft-excel-365/) – It is used to extract digits from the given number as well.
- [**SUBSTITUTE Function**](https://geekexcel.com/how-to-use-substitute-function-in-microsoft-excel-2013/) – Using this function, you can replace existing text with new text in a text string when you want to replace text based on its content, not position.
- [**REPT Function**](https://geekexcel.com/how-to-use-rept-function-in-microsoft-excel-2013/) – This function helps to repeat characters a given number of times.
- [**FIND Function**](https://geekexcel.com/how-to-use-find-function-in-microsoft-excel-365/) – Helps to find out the one text string inside the other.

## Practical Example:

Assume that you have input data as per the below image. Here, you need to extract all the mail id specified by the @ symbol. Let’s see how could we solve this job in Excel.

- First, you need to enter the **input data**.

![Input Range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Input-Range-15.png)<figcaption id="caption-attachment-21455">Input Range</figcaption>

- **Apply** the above-given **formula** into a blank cell where you want to get the results.

![Enter the formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Enter-the-formula-25.png)<figcaption id="caption-attachment-21456">Enter the formula</figcaption>

- Then **press**  **ENTER** key to get the results.
- After that, drag the formula cell, and you will get the following result.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Result-46.png)<figcaption id="caption-attachment-21457">Result</figcaption>

## Verdict:

Hope you understood **how to extract the word from the text string that contains a special character in Excel**. Make use of this. Please state your **query** in the below **comment** box. I reply to queries frequently. Thanks for visiting **[Geek Excel!!](https://geekexcel.com/)** Keep Learning!!

### Related Articles:

- **[How to Extract Text Before Nth Specific Character in Excel?](https://geekexcel.com/extract-text-between-nth-specific-character-excel/)**
- **[Extract Text Before First Comma or Space in Excel Office 365!!](https://geekexcel.com/extract-text-before-first-comma-or-space-in-excel-office-365/)**
- **[How to Extract the Text Between Brackets? Simple Guide!!](https://geekexcel.com/how-to-extract-text-between-brackets/)**