Forum Discussion
rbdaves
Sep 27, 2022Copper Contributor
How do I create a comma delimited list from excel email address column
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...
Martin_Weiss
Sep 28, 2022Bronze Contributor
Hi rbdaves
if you have Excel 2019 or newer, there is a function TEXTJOIN, that does exactly what you need:
=TEXTJOIN(", ",TRUE,A1:A7)