Login / Sign up
Table transformations

How to extract an email address from text in Excel

2026-06-20
Task

The source table has a free-text comment column. Somewhere inside the text there is an email address that must become a separate email column.

Short answer

In email, use comment as the source and add one regex rule that removes everything except the email pattern.

Before / After

Before

source data
idcomment
1001Contact: buyer@example.test, urgent
1002Write to sales@store.fr

After

result
idemail
1001buyer@example.test
1002sales@store.fr

Where to Open Settings

  1. Opening the email column settings in Eofferix
    Open the settings under email; the source column is comment.

How to Do It in Eofferix

  1. Add a transformation: condition Regular expression, value [A-Za-z0-9._%+\-]+@[A-Za-z0-9.\-]+\.[A-Za-z]{2,}, action Remove everything except.
    Regex rule that extracts an email address from text
    The rule keeps only a substring that looks like an email address.
  2. Save the column settings, save the template, then on the final step run the transformation.

Process data faster with Eofferix

Create a free account to automate catalogs and price lists around your own rules.

Sign up