Thread: Cant merge cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
albertmb albertmb is offline
external usenet poster
 
Posts: 81
Default Cant merge cell

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

"Dadada" wrote:

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