Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
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.
1 Answer
- CanadaRAMLv 79 years agoFavorite 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
