Get the email part before the at sign

Turn Ava.Reed+team@example.org into Ava.Reed+team, exactly as typed.

What you'll make

In Excel: Ava.Reed+team@example.org becomes Ava.Reed+team.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8The email address."Ava.Reed+team@example.org"
2"@"Where to stop: the @ sign."@"
3TEXTBEFORE( … )Keeps the text before the @, exactly as typed."Ava.Reed+team"

Plus signs, dots and capitals stay. The addresses here are made-up.

=TEXTBEFORE(A8,"@")

How to use it

Yellow bar at the top? Click Enable Editing.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. Use your own list. Paste emails into the green column of the Template tab. The text before the @ fills in by itself.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

This isn't a person's name. Don't use it in a greeting, and it doesn't check the address works.

Microsoft's help: TEXTBEFORE function