How to Extract Certain Text from Cells in Excel Office 365?
Tags: extractcertaintextfr, kutoolsexceltutorial, kutools
Published: 2020-11-03 11:50:47

---
title: How to Extract Certain Text from Cells in Excel Office 365?
published: true
date: 2020-11-03 11:27:23 UTC
tags: ExtractCertainTextfr,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/how-to-extract-certain-text-from-cells-in-excel-office-365/
---

In this tutorial, we will guide you to know the steps to **Extract Certain Text from Cells in Excel Office 365** using **Kutools.** 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)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Extract Text Between Two Symbols:

If you want to extract the text strings between two symbols in the cells, do as follows.

- Let’s consider the following example where you can see the input text strings. Some text is given between the symbols **{ } curly brackets**.

![Example data](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Example-data.png)<figcaption id="caption-attachment-16785">Example data</figcaption>

- We will see the steps to know how to extract them.
- First, you need to **select the text strings** that you want to extract certain text.
- Go to the **Kutools Tab, select** the **Text** option, **choose** the **Extract Text** option.

![Select the Extract Text option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Extract-Text-option.png)<figcaption id="caption-attachment-16786">Select the Extract Text option</figcaption>

- Now, it will open the **Extract Text Dialog Box**.
- **Text box –** You need to enter **{\*}** and **click** the **Add** button.
- **Extract list** – After clicking the add button, it will add this condition to this list box.

![Click the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Click-the-OK-button-3.png)<figcaption id="caption-attachment-16789">Click the OK button</figcaption>

### Note:

- **\***  **– ** This symbol refers to the criteria which match ant string characters such as numbers, alphas, symbols, and so on.
- If there are any other extract rules selected in the **Extract list,** you need to uncheck all the rules except the newly added one.

- Now, **hit** the **OK** button, and a prompt box will pop-out to ask you for selecting any cell to display the result.

![Select any cell](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-any-cell.png)<figcaption id="caption-attachment-16790">Select any cell</figcaption>

- Then, **click** the **OK** button.
- At last, you can see that the text strings with the curly brackets have been extracted as shown in the below screenshot.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Result-4.png)<figcaption id="caption-attachment-16791">Result</figcaption>

## Steps to Extract Domains from Email Addresses:

Use the **Extract Text** feature of kutools to extract the domains from the email addresses. To do this, follow the below instructions.

- You need to **select the Email addresses** which you want to extract their domains.

![Sample data](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-3.png)<figcaption id="caption-attachment-16792">Sample data</figcaption>

- On the **Kutools Tab, select** the **Text** option, **choose** the **Extract Text** option from the menu.

![Select the Extract Text option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Extract-Text-option.png)<figcaption id="caption-attachment-16786">Select the Extract Text option</figcaption>

- Now, it will open the **Extract Text Dialog Box**.
- **Text box –** You need to enter @\* and **click** the **Add** button.
- **Extract list** – After clicking the add button, it will add this condition to this list box.

![Extract Text Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-2.png)<figcaption id="caption-attachment-16793">Extract Text Dialog Box</figcaption>

- Now, **hit** the **OK** button, and a prompt box will pop-out to ask you for selecting any cell to display the result.

![Select any cell](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-any-cell.png)<figcaption id="caption-attachment-16790">Select any cell</figcaption>

- Then, **click** the **OK** button.
- At last, you will get the result as shown in the below image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/3-2.png)<figcaption id="caption-attachment-16794">Output</figcaption>

## Wrap-Up:

In this tutorial, we guided you to learn the steps to **Extract Certain Text from Cells in Excel Office 365** using **Kutools. ** Don’t forget to share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Keep Reading:

- [Extract Numbers From Mixed Text String with Function in Excel 365!!](https://geekexcel.com/extract-numbers-from-mixed-text-string-with-function-in-excel-365/)
- [How to Extract Substring Between Two Texts in Excel?](https://geekexcel.com/how-to-extract-substring-between-two-texts-in-excel/)