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