View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Penny Penny is offline
external usenet poster
 
Posts: 33
Default Merge the contents of multiple cells into one cell

I've merged contents of multiple cells into one and now that I don't need A2
and B2 Cells, the information from the merge disappears if i delete those two
cells. How do I stop this?

Example below:

A2: 869000471
B2: 02810
C2: 86900047102810

The formula that I used was =A2&""&B2