Format a display name and email pair

Turn Ava Reed and ava@example.com into Ava Reed <ava@example.com>.

What you'll make

In Excel: Ava Reed + ava@example.com becomes Ava Reed <ava@example.com>.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8The display name."Ava Reed"
2&" <"&Adds a space and the < sign."Ava Reed <"
3B8Adds the email address."Ava Reed <ava@…"
4&">"Adds the > sign at the end."Ava Reed <…>"

Read it left to right. Each & joins the next piece on. 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. Paste display names into column A and email addresses into column B of the Template tab.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Names with commas, quote marks or < > signs need a look first. This simple pattern doesn't handle them.