Cant merge cell

  • Thread starter Thread starter Dadada
  • Start date Start date
D

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