how do I merge two adjacent cells and keep the data from both cell
 

To take it a step further, I also need the formats to remain the same.
ie...the left column data is Left-text-justified, and the right column is
Right-text-justified.

how do I merge two adjacent cells and keep the data from both cell
 

=A1 & " " & B1


--
Regards
Dave Hawley
www.ozgrid.com
"johncaleb" wrote in message
...
To take it a step further, I also need the formats to remain the same.
ie...the left column data is Left-text-justified, and the right column is
Right-text-justified.