Forum Discussion

rbdaves's avatar
rbdaves
Copper Contributor
Sep 27, 2022

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 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

mailto:email address removed for privacy reasons

mailto:email address removed for privacy reasons

mailto:email address removed for privacy reasons

etc.

 

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

 

Formulas and Functions

1 Reply

  • Martin_Weiss's avatar
    Martin_Weiss
    Bronze Contributor
    Sep 28, 2022

    Hi rbdaves 

     

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

     

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

     

Resources