How do I create a comma delimited list from excel email address column

Question

I have tried to find an answer to this question on my IPad and I don’t think it is possible. So I am going to try this on my PC.

I have a spreadsheet with a column of email addresses. I want to create a comma delimited list for use as an email address list in my Google Mail.

Example of my email list in an Excel column

email address removed for privacy reasons

etc.

What I want: email address removed for privacy reasons, email address removed for privacy reasons, email address removed for privacy reasons

martin_weiss · Answer

Hi&nbsp;rbdaves&nbsp;&nbsp;if you have Excel 2019 or newer, there is a function TEXTJOIN, that does exactly what you need:&nbsp;=TEXTJOIN(", ",TRUE,A1:A7)&nbsp;

Forum Discussion

How do I create a comma delimited list from excel email address column

Share

Resources