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