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

rbdaves · ‎Sep 27 2022

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

etc.

Martin_Weiss · ‎Sep 28 2022

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

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

Products (50)