Cant merge cell
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 |
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 |
Cant merge cell
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 -- Max Singapore --- "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 |
All times are GMT +1. The time now is 05:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com