Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
merge cell | Excel Discussion (Misc queries) | |||
how to merge many cell to one cell with keeping all data | Excel Worksheet Functions | |||
How to merge one cell from many workbooks to one cell on one work | Excel Worksheet Functions | |||
Merge cell & Copy Data from different cell | Excel Discussion (Misc queries) | |||
How do I merge 2 cells for ex. DE (1 cell) & 01234 (2 cell) into . | Excel Discussion (Misc queries) |