I've got a list of over 170 names in excel rows that I need to quickly turn into a copy and paste list that I can mass email some of my sales people.
Example:
[email protected]
[email protected]
I need to combine the names and separate by a semi colon: [email protected]; [email protected]
I started a concatenate formula, but because each name is on different row, it was a lot of manual formula tweaking.
How do I do this the smart way?
Bookmarks