Merge the contents of multiple cells into one cell

[Penny]

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

 

[Gary''s Student]

Copy C2 and paste/special/value back onto C2

 

[Dave Peterson]

You sure you kept the leading 0 that appeared in B2?

If those values are really numbers, you may want:

=text(a2,"000000000")&text(b2,"00000")
(no need for &""&)

After you've created the formula, you can select those formula cells (all of
column C) and do:

select column C
Edit|copy
edit|paste special|values

And delete columns A and B

 

[Penny]

Thank you both for your help.. !!!

You sure you kept the leading 0 that appeared in B2?

If those values are really numbers, you may want:

=text(a2,"000000000")&text(b2,"00000")
(no need for &""&)

After you've created the formula, you can select those formula cells (all of
column C) and do:

select column C
Edit|copy
edit|paste special|values

And delete columns A and B