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

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

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