How to Extract Email Address from Text String in Excel Office 365?
Tags: extractemailaddresse, kutoolsexceltutorial, kutools
Published: 2020-11-02 12:06:24

---
title: How to Extract Email Address from Text String in Excel Office 365?
published: true
date: 2020-11-02 11:57:21 UTC
tags: ExtractEmailAddresse,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/how-to-extract-email-address-from-text-string-in-excel-office-365/
---

In this tutorial, we will guide you to learn the steps to **Extract Email Addresses from Text String 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 Email Address from a Text string in a Cell/Range:

To extract an email address from the text string in a cell or range, do as follows.

- Kindly, **select a cell or range** you want to extract the email address. Refer to the below image.

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

- Go to the **Kutools Tab, select** the **Text** option, **choose** the **Extract Email Address** option from the menu.

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

- Now, the **Extract Email Address dialog box** will pop-out to ask you the place where you want to get the result. So, you need to **select a cell to print the result**.

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

- Then, you need to **click** the **OK** button.
- Finally, you can see the extracted email addresses in the specified cell or a range as shown in the below image.

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

## Steps to Extract Multiple Email Addresses:

Kutools can help you to extract multiple email addresses from a text string, to do this, follow the below steps.

- You need to **select a cell or range** that you want to extract email addresses.

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

- Go to the **Kutools Tab, select** the **Text** option, **choose** the **Extract Email Address** option from the menu.

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

- Then, the **Extract Email Address dialog box** will be displayed.
- You need to **select a cell** to display the result and **click** the **OK** button.

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

- After that, you will see the extracted email address in the specified cell or range as shown in the below screenshot.

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

## Verdict:

In this tutorial, you can easily understand the steps to **Extract Email Addresses from Text String in Excel Office 365** using **Kutools. ** Leave your **suggestions** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [How to Select Cells Based on Color/Formatting in Excel Office 365?](https://geekexcel.com/wp-admin/post.php?post=16618&action=edit)
- [How to Open Containing Folder or Directory of Current Workbook in Excel?](https://geekexcel.com/wp-admin/post.php?post=16394&action=edit)