Extract Email Addresses From Text in Excel 365 Easily

How-to basics · Updated November 18, 2026

In Microsoft 365 Excel, use REGEXEXTRACT to pull email addresses from a text cell: with the text in A2, enter =IFERROR(REGEXEXTRACT(A2,"[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,}",1),""). The formula returns every match it finds, spilling the results into cells to the right; the pattern is practical for common addresses, but it is not a complete test of whether an address exists or is valid.

What the formula does

REGEXEXTRACT searches text for a pattern and returns the part that matches. In the formula above, the pattern looks for a familiar email-address structure: characters commonly found before an at sign, an at sign, a domain name, a dot, and a suffix of at least two letters. The final argument, 1, asks for all matches rather than only the first one.

For example, if A2 contains Contact Maya at maya.chen+events@example.org; copy support@example.com., the formula returns two results: maya.chen+events@example.org and support@example.com. Excel places the results in adjacent cells on the same row, starting where you entered the formula.

The formula uses a regular expression, often shortened to regex. The backslash before the dot means the pattern treats that dot as a literal period rather than as a special symbol. In an Excel formula, the pattern is enclosed in straight double quotation marks. If you copy the formula into Excel, keep the backslash and punctuation as shown.

Set up the worksheet

Put the source text in one column and leave enough blank cells to the right of the formula for its results to spill. For a simple list, place each text entry in a separate row, with the first entry in A2. Put the formula in B2. If each row contains multiple addresses, the results for that row spill horizontally from B2.

  1. Enter or paste the text into column A, one record per row.
  2. Enter the formula in B2 and press Enter.
  3. Check the returned matches. If the formula produces several addresses, make sure the cells to the right of B2 are empty so the spill can appear.
  4. Copy the formula down column B for other source rows. In Microsoft 365, you can drag the fill handle or copy and paste it into the needed rows.

When you copy the formula down, the reference changes from A2 to A3, A4, and so on. If a source cell contains no match, IFERROR returns a blank instead of displaying an error. If you need a clean, single-column list for a mailing tool or a review, the horizontal spill layout may need rearranging; copy the results and use Paste Special > Values before restructuring them, so the extracted text is retained rather than the formula.

Why results spill across columns

With the third argument set to 1, REGEXEXTRACT returns an array containing all matches. Excel’s dynamic-array behavior displays that array in neighboring cells automatically. The first address appears in the formula cell, and additional addresses appear to its right. You do not need to copy the formula into each neighboring cell.

A spill error usually means that one or more cells in the required output area are not empty. Check for values, spaces, or merged cells to the right of the formula and clear or move them. If the source contains only one matching address, only one result is needed. If it contains none, the formula above displays a blank because of IFERROR.

Results from multiple source rows do not automatically combine into one continuous list: each formula spills within its own row. That can be useful when you want to preserve which source record supplied each address. If you need a single list, first consider how you want to retain that relationship. A separate output sheet or a copied-values step can make it easier to review and remove duplicates without changing the source data.

How well does the pattern recognize email addresses?

The pattern is designed to extract common email formats, including a plus sign in the part before the at sign, such as alex+orders@example.com. It also permits periods, underscores, hyphens, and percent signs in that part, and periods and hyphens in the domain. It is intentionally useful rather than a full implementation of every technical rule that can apply to email addresses.

That distinction matters. A regex match only means the text fits the pattern. It does not establish that the domain is registered, that the mailbox exists, or that the person can receive messages. Nor does this simple pattern check every edge case permitted by email standards. It may miss unusual but legitimate addresses, and it can accept a malformed string that resembles an address. Treat the results as candidates to review, especially before contacting people or importing the list into another system.

The pattern also expects a suffix of at least two letters, so it may not capture unusual or nonstandard text that does not fit that assumption. A change to the pattern can broaden or narrow the matches, but making it overly permissive can return unwanted fragments. For routine cleanup of copied messages, support notes, or contact text, a straightforward pattern is often easier to inspect than an elaborate one.

When the formula is not available

REGEXEXTRACT is available in Microsoft 365 Excel, but the function may not be present in every installation or update channel at the same time. If Excel displays #NAME?, check that the application is updated and that your version supports the function. Excel for the web and Mac versions can differ in rollout timing, so verify availability in the version you are using. The steps and formula are intended for Microsoft 365 on Windows.

In older Excel versions without REGEXEXTRACT, there is no equally simple built-in formula for finding any number of email addresses in arbitrary text. If the data is small, searching for the at sign with Find (Ctrl+F on Windows; Command+F on Mac) can help locate records for manual review, but it does not extract and validate a list automatically. Power Query, opened from Data > From Table/Range after turning the source range into a table, can help reshape and clean repeatable datasets. However, Power Query does not make the formula above available automatically; the extraction logic must be designed for the structure of the data.

Clean and check the extracted list

Before using the results, inspect a sample against the original text. This is particularly important when entries contain punctuation, line breaks, names next to addresses, or text copied from web pages. The pattern excludes common trailing punctuation such as a comma or closing parenthesis, but source formatting can still produce unexpected matches.

  • Keep the original text column. It provides a reference if a result looks incomplete or suspicious.
  • Check addresses that end at a line break or contain unusual characters; the pattern may not cover every legitimate format.
  • Look for duplicates before sending, uploading, or merging the addresses. Repeated matches can arise when the same person appears in several source records.
  • Use a separate output area for any cleanup, and paste values if you want a fixed list that no longer depends on the source formula.

Removing duplicates is not always the right choice. Two identical addresses in different records may signal a shared contact, repeated transaction, or data-quality issue worth investigating. Preserve a link to the original row if the extracted addresses need to be audited or matched back to their source.

Privacy and responsible handling

Email addresses are personal or business contact information in many contexts. Extract only information you are authorized to process, and consider who can access the workbook. If the source text comes from customer records, support messages, or a shared file, follow the organization’s retention and access rules. Avoid distributing a workbook containing addresses more broadly than necessary.

Extraction itself does not send messages or contact anyone; it simply creates matching text in worksheet cells. Still, a clean-looking list can encourage use beyond the original purpose. Review the source and the intended use, and do not assume that an address appearing in a text field is permission to add it to a mailing list.

Frequently Asked Questions

Can Excel extract more than one email address from a cell?
Yes. In the formula shown, the third argument of REGEXEXTRACT is 1, which returns all matches as a spill array. The results appear across the row, so clear the cells to the right if Excel reports a spill problem.

How do I extract only the first email address?
Change the third argument of REGEXEXTRACT from 1 to 0. With the source text in A2, use =IFERROR(REGEXEXTRACT(A2,"[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,}",0),""). This returns the first match, or a blank when no match is found.

Why does Excel show #NAME? for REGEXEXTRACT?
Your Excel installation may not have the function available, or the application may need an update. Confirm that you are using a Microsoft 365 version with regex functions. If it remains unavailable, use a supported version or a different workflow rather than assuming the formula is valid in that installation.

Does a match prove the email address is real?
No. It only shows that the text matches the pattern. It cannot confirm the domain, mailbox, or permission to contact the person. Review the extracted addresses and use an appropriate verification process if accuracy is important.

Can I extract addresses from an entire column at once?
The formula is easiest to manage one source cell per row: enter it beside the first record and fill it down. Each row can return a different number of matches, so the results spill horizontally rather than forming one combined column automatically.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.