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?
Solved
Combining 2 columns with email addresses
Best answer by Kamille_Parks11
Try something like:
{Email Field 1} & ", " & {Email Field 2}
(This assumes the multiple emails in the second field are already comma-separated)
+25Try something like:
{Email Field 1} & ", " & {Email Field 2}
(This assumes the multiple emails in the second field are already comma-separated)
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.