Sep 27 2022 03:42 PM
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
Sep 28 2022 12:54 AM
Hi @rbdaves
if you have Excel 2019 or newer, there is a function TEXTJOIN, that does exactly what you need:
=TEXTJOIN(", ",TRUE,A1:A7)