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