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

Merge the contents of multiple cells into one cell
 

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

Merge the contents of multiple cells into one cell
 

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 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

--

Dave Peterson

Merge the contents of multiple cells into one cell
 

Thank you both for your help.. !!!


"Dave Peterson" wrote:

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 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

--

Dave Peterson