col1 col2

1 1,2,3,4
2
3
4

I have data in col1 and I want to transfer the data into col2 with this
lay out :

1,2,3,4

I used this syntax:

=CONCATENATE(A1,",",A2,",",A3,",",A4)

Questions:

Is there a better way to create a short program to do this? assuming
my data is 1 to 500

Thanks


--
tbobo
------------------------------------------------------------------------
tbobo's Profile: http://www.excelforum.com/member.php...o&userid=31530
View this thread: http://www.excelforum.com/showthread...hreadid=512511