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

Occasional Contributor

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

email address removed for privacy reasons

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

 

1 Reply

Hi @rbdaves 

 

if you have Excel 2019 or newer, there is a function TEXTJOIN, that does exactly what you need:

 

=TEXTJOIN(", ",TRUE,A1:A7)

Martin_Weiss_0-1664351616139.png