Exceljet

Quick, clean, and to the point

Create email with display name

Excel formula: Create email with display name
Generic formula 
=name&" <"&email&">"
Summary 

To create an email address with a display name, you can use concatenation. In the example shown, the formula in D5, copied down, is:

=B5&" <"&C5&">"

The result is a text string that contains both the name and email address enclosed in angle brackets (<>).

Explanation 

Some applications show an email addresses together with a "display name", where the name appears first, followed by the email address enclosed in angle brackets (<>). The goal in this example is to create a format like this based on an existing name and email address.

In the worksheet shown, column B contains a name, and column C contains an email address. The formula in column D uses the ampersand character (&) to join the name and email address together:

=B5&" <"&C5&">"

This is an example of concatenation. On the right side of the formula, the email address in C5 is wrapped in angle brackets:

" <"&C5&">"

Notice the angle brackets are text and must be enclosed on double quotes (""). Also notice that opening bracket (<) begins with a space character. This allows us to join the name directly to the left side:

=B5&" <"&C5&">"

The result is the name followed by a space character, followed by the email address in angle brackets.

Concatenation functions

In the example shown, the ampersand operator (&) is used to concatenate the name, email, and angle brackets manually. The ampersand is a flexible way to concatenate text strings, because it can be used in a formula anywhere. However, Excel also has three functions dedicated to concatenation: CONCATENATE, CONCAT, and TEXTJOIN. Both CONCATENATE and CONCAT can be used to to solve the same problem like this:

=CONCATENATE(B5," <",C5,">")
=CONCAT(B5," <",C5,">")

Note that the CONCATENATE function is now technically replaced by the CONCAT function, which was first released in Excel 2019. The TEXTJOIN function is primarily designed to concatenate ranges.

Author 
Dave Bruns

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.

Download 100+ Important Excel Functions

Get over 100 Excel Functions you should know in one handy PDF.