Help

Combining 2 columns with email addresses

Topic Labels: Formulas
Solved
Jump to Solution
1347 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Dippity
6 - Interface Innovator
6 - Interface Innovator

I have 2 fields that contain email addresses. The first column contains 1 email address and the the 2nd column contains multiple email addresses. I want to create a 3rd column that combines both fields with the appropriate commas separating each email address. What formula can I use?

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus

Try something like:

{Email Field 1} & ", " & {Email Field 2}

(This assumes the multiple emails in the second field are already comma-separated)

See Solution in Thread

2 Replies 2
Kamille_Parks
16 - Uranus
16 - Uranus

Try something like:

{Email Field 1} & ", " & {Email Field 2}

(This assumes the multiple emails in the second field are already comma-separated)

Dippity
6 - Interface Innovator
6 - Interface Innovator

Thanks for the quick response @Kamille_Parks!