ppleasebob
Board Regular
- Joined
- Dec 23, 2002
- Messages
- 145
Hello Board,
I have a list of 3,000 customers email address, currently in a single column, I need to paste them into a single cell (or as many as possible into a single cell) separated by a comma, so I can drop them into a bulk emailer on our website,
I have concatenated a comma on to the end of each one, but need a way of putting the comma'd addresses into the single cell, without selecting the cell typing a comma then the next cell etc..
I thought that I could paste special transpose, the list and then 'merge' it into one cell?
Any thoughts, ideas
Thanks
Bob
Ps the email address list is genuine - (and not for sale!)
I have a list of 3,000 customers email address, currently in a single column, I need to paste them into a single cell (or as many as possible into a single cell) separated by a comma, so I can drop them into a bulk emailer on our website,
I have concatenated a comma on to the end of each one, but need a way of putting the comma'd addresses into the single cell, without selecting the cell typing a comma then the next cell etc..
I thought that I could paste special transpose, the list and then 'merge' it into one cell?
Any thoughts, ideas
Thanks
Bob
Ps the email address list is genuine - (and not for sale!)