Build an email address from its two parts

Turn ava and example.com into ava@example.com from approved parts.

What you'll make

In Excel: ava + example.com becomes ava@example.com.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8The part that goes before the @."ava"
2&"@"&Adds the @ sign."ava@"
3B8Adds the part that goes after the @."ava@example.com"

Read it left to right. The addresses here are made-up.

=A8&"@"&B8

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. On the Template tab, paste the part before the @ into column A. Put the part after it into column B.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Use only parts you know are right. This joins them but can't tell if the address works.