In Excel, how do I put commas behind all the entries in a column?
If I import a list of email addresses from a website, how do I make sure each one has a comma behind it? I need the commas as part of the input for another web site.
If I import a list of email addresses from a website, how do I make sure each one has a comma behind it? I need the commas as part of the input for another web site.
CanadaRAM
Favorite Answer
If the addresses are in column A, Create another column with a formula in it,
=TRIM(A1)&","
The Trim command will get rid of leading and trailing spaces in the original data.
If you want to "freeze" the calculation, then highlight the calculated results, Copy, and then Paste Special... Values only. This will remove the live calculation and just leave the text result