Cant merge cell

[Dadada]

When I merge two cells , the contents of which are X and Y, I get only one X
in the merged cell. Worthless...
I would like to get XY

 

[albertmb]

This is not possible in Excel, but if you wish you can use this formula in
another cell,
If X is in cell A1 and Y is in cell B1, you can write this formula in any
cell:

=CONCATENATE(A1,B1)

I am no expert, maybe somebody else can come up with a better solution

Regards

 

[Max]

That's the way it is, only the leftmost cell contents are retained. Anyway,
its best not to use merged cells as they can pose all sorts of downstream
problems. If you want to concat the result XY, you could also just use, eg in
C2: = A2&B2, where X and Y are housed in A2 and B2. The ampersand "&" is the
concat operator. Success? hit the YES below