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
