How to Concatenate Email Addresses in Excel – 4 Methods

This is the sample dataset.

Method 1 – Using the Ampersand to Concatenate Email Addresses in Excel

Steps:

• In C11, enter the following formula

• Press Enter button to see the merged emails in a string.

Read More: How to Concatenate Decimal Places in Excel

Method 2 – Using the CONCATENATE Function to Combine Email Addresses

The CONCATENATE function is used to combine values.

Steps:

• Enter the following formula in C11

• Press Enter.

Method 3- Using the TEXTJOIN Function to Merge Email Addresses in Excel

Use the TEXTJOIN function to merge a list of emails.

Steps:

• Select C11 and enter the following formula.

• Press Enter.

Read More: How to Concatenate Different Fonts in Excel

Method 4 – Embedding an Excel VBA to Merge Email Addresses

Steps:

• Press Alt + F11 to open the VBA window.
• Click Insert > Module to insert a new module.

• Enter the following code in the module.

Function Concatenate_EmailAddresses(myRange As Range) As String
Dim Con_Cell As Range
For Each Con_Cell In myRange
Concatenate_EmailAddresses = Concatenate_EmailAddresses & ";" & Con_Cell.Value
Next Con_Cell
Concatenate_EmailAddresses = Right(Concatenate_EmailAddresses, Len(Concatenate_EmailAddresses) - 1)
End Function

• Go back to your worksheet and you will see the output.

Here’s our user-defined function (UDF)

• Enter the following formula in C11.

• Press Enter.

Download Practice Workbook

Download the free Excel workbook here.