Have you tried to export the Excel data as a *.csv file (Comma Seperated
Values)?

Simply File, Save As, choose DOS *.csv file extension and you should be good
to go. You may have to clean up the data first though.

"jgkocis" wrote:


Hi-

I have a list of about 1,500 email addresses. To send an email I need
to have a comma between each entry. I know I can use the formula
=(A1&,",",&A2) to concatenate cells A1 and 2, with a comma between the
2 strings, but is there a formula to automatication do it for A1 -
A1500???

Or is there an entirely different approach I should consider?

Thanks


--
jgkocis
------------------------------------------------------------------------
jgkocis's Profile: http://www.excelforum.com/member.php...o&userid=31477
View this thread: http://www.excelforum.com/showthread...hreadid=511559