Merge Cells

[Caine Sanchez]

I am currently trying to merge two cells that have numbers and i need to
merge them. e.g cell A1 = 0101 Cell A2 = 01. I want to merge these two cells
and the final figure should be 010101. Is there a way in excel to do this as
i have tried numerous ways without joy.

 

[Dave Eade]

I think you have to change the format of the values from "numeric" to "text",
for each cell in the merge select "format" from the menu, then "cells" , then
"category" text.

 

[Pete_UK]

If you merge cells, then you will lose some of the contents of those
cells. Usually the contents of the top left cell remains.

If you mean that you need to merge the values, then you could do so
like this in another cell:

=TEXT(A1,"0000")&TEXT(A2,"00")

Hope this helps.

Pete

 

[Tracey]

have you tried "Concatenate"?

=CONCATENATE(A1,A2)

 

[John]

Make sure you format your cells as Text, then use
=CONCATENATE(A1,A2)
HTH
John

 

[Brad]

The others suggested concantenation - this is another approach
In A3 have the equation =A1*100+A2, you might need to use custom format to
retain the leading zeros....