MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Merging - Combining rows in a single column

Posted by Steve on January 23, 2002 3:08 PM

How can I merge/combine the data (company, address, city, etc) that are in 4 continuous rows into one cell with all the info in it. when I merge the cells only the upper left data remains. I want all the address info in one cell that can be wrapped.

Posted by Greg Rogers on January 23, 2002 3:27 PM

try this formula in an empty cell:
=A1 & " " & A2 & " " & A3 & " " & A4

Posted by bea harris on January 29, 2002 2:19 PM