With the data in A1:A7 or any array, alter the cell references, try
=A1&";"&A2&";"&A3&";"&A4&";"&A5&";"&A6&";"&A7
Regards,
Alan.
"moglione1" wrote
in message ...

Does anybody know if you can concatenate multiple rows.

E.g. I have

12
13
70
99
01
02
76

I want to put these into one cell seperated by ; E.g.
12;13;70;99;01;02;76


--
moglione1
------------------------------------------------------------------------
moglione1's Profile:
http://www.excelforum.com/member.php...o&userid=26414
View this thread: http://www.excelforum.com/showthread...hreadid=396874