Thread: how do I merge two adjacent cells and keep the data from both cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
ozgrid.com ozgrid.com is offline
external usenet poster
  
Posts: 464
Default 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.

Reply With QuoteReply With Quote