Home » Posts

Create email with display name

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&" " The result is a text string that contains both the name and email address enclosed in angle brackets ().

April 14, 2025 · 1 min · 44 words · Lisa Thompson

In the worksheet shown, column B contains a name, and column C contains an email address.

Also notice that opening bracket (<) begins with a space character.

However, Excel also has three functions dedicated to concatenation:CONCATENATE,CONCAT, andTEXTJOIN.

Excel formula: Create email address from name

TheTEXTJOIN functionis primarily designed to concatenate ranges.

Excel formula: Get name from email address

Excel formula: Get domain name from URL

Excel formula: Get top level domain (TLD)

Excel formula: Get domain from email address

Excel CONCAT function

Excel CONCATENATE function

Excel TEXTJOIN function