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