concatenate would work in this instance


ie

=concatenate(a1,b1,c1 etc etc)


that way all would be in one cell, you can always add a commar too if
need be.

Then copy and paste the values and then save as a CSV file..


--
mr_ben
------------------------------------------------------------------------
mr_ben's Profile: http://www.excelforum.com/member.php...o&userid=37106
View this thread: http://www.excelforum.com/showthread...hreadid=568446