Forum Discussion
deleting commas at end of email addresses
I recently got a new computer with new office 365. I email thousands, and I've always added commas at the end of each email address, thinking it would aid in mailing (and outlook has been fine with it on my old computer!) BUT, I've just found out that outlook will now not allow me to mail to those addresses with the commas......right! It tells me I have to eliminate the commas & separate with semi-colons.
Is there a way that I can get all those commas (all at the end of email addresses in one list) removed instead of manually doing each one? I'm going crazy here!
Thanks!
3 Replies
Power Query Method.
To remove commas as seen in the caption above:
1. Click in data and execute CTRL + T.
2. In the Create Table box, click OK
3. Execute ALT+ APT on your keyboard
4. In the PQ editor, select Email column and execute ALT + HSP
5. Select By Delimiter
6. Type in (,) in the box below Custom
7. Click OK.
The commas are removed as seen in the caption below
Finally, select Close and Load to load the result back to Excel
You may follow these steps to replace the existing commas with semicolon in one go...
- Select all the cells with commas in there which you want to replace.
- Press Ctrl+H to open Find and Replace window.
- In Find what box, type a comma ,
- In Replace with box, type a semicolon ;
- Click on Replace All button to replace all the commas in the selected cells with semicolons.
