Assume A1:A1000 is your data:

B1000 = CONCATENATE(A1000,B1001) (Copy up)

Then B1 should be what you are looking for.


Hope this helps.


Yagnesh Wrote:
I tried the Concatenate function but it only limits 30 cells I could
merge. I have a row of about 1,000.


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=390758