Copy C2 and paste/special/value back onto C2
--
Gary''s Student - gsnu200826


"Penny" wrote:

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