Microsoft Excel

Extract email addresses from a text string in Excel

Chris Menard

24 Feb 2018 — 1 min read

Extracting email address from a text string in Excel can be tricky. I made a video demonstrating three methods of extracting the email addresses. I also showed how to take the email addresses and add a comma between them. This is handy when you need to import the email addresses into an LMS or another system.

Three ways to separate the data

1. Mid and Find Function in Excel. 2. Flash Fill in Excel 2013 and Excel 2016 for Windows. 3. Text to Columns for any Excel version.

One of my favorite features in Excel is Find and Replace. I’ll use Replace to get the email address to show up properly.

**CTRL + H** is the keyboard shortcut for Replace.

YouTube Video – Extracting email addresses

Excel: extract email addresses from data by Chris Menard

TimeStamps in the video

- 00:00 Intro - 01:00 Mid and Find Function – Method 1 - 01:45 Flash Fill – Method 2 - 02:37 Text to Columns – Method 3 - 03:20 CTRL + H to lose > on Method 3 - 04:05 Add commas with a 3D reference - 05:30 TEXTJOIN function in Excel

TEXTJOIN Function

The TEXTJOIN function combines the text from multiple ranges and/or strings and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges. Textjoin only works in Excel 2016 with an Office 365 subscription.

Flash Fill In Excel

Flash Fill is an easy way to join text together or break out text. Example: if you have “Bill Smith” and want to break out the first name from the last name in other columns, Flash Fill will do it. Flash Fill will also work the other way and join names together. If Flash Fill is not turned on, you can turn it on my going to File, Options, Advanced, and turn on Flash Fill, click OK. Flash Fill only works in Excel 2013 and Excel 2016.

Flash Fill in Excel with Len Function by Chris Menard

Count Unique Values in Excel with UNIQUE, SORT, and COUNTIF Functions Tutorial

Table of Contents * 📋 Why this method works and when I use it * 📋 Setting up the table * 🔎 Extract distinct values with UNIQUE * ↕️ Sort the unique list with SORT * 🔢 Count occurrences using COUNTIF * ✅ Why tables beat ranges for this task * 🔁 When to use this instead of a pivot table * 🔧 Quick checklist to

Financial Ratios - Formula Completion in Excel using Copilot

Writing formulas in Excel can be time-consuming and challenging, even for experienced users. Selecting the right function, referencing the correct cells, and ensuring proper syntax often slows down workflows and leads to errors. Many users spend extra time troubleshooting mistakes, searching for examples, or trying to recall the exact formula

Excel Formula Completion - Using XLOOKUP

I tested how well Excel's formula completion with Copilot handles a multi-step calculation that would normally require a nested function. The goal was simple: calculate profit by subtracting the total cost of units sold from total revenue, with unit costs stored in a separate lookup table. Instead of

Copilot in Teams Meetings without Transcription: Use AI While Respecting Privacy

Microsoft Teams has a great Copilot feature. A Microsoft 365 license is required for this feature. In a Teams meeting, I need AI assistance during a conversation, but the participants do not want the call recorded or transcribed. There are plenty of situations where privacy matters: a vendor asks for