Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have imported a word table into excel. Some of the word cells have several
paragraphs - and when imported they end up in individual cells - e.g. A1, A2 and A3. Now I want to merge all three cells into one - but I want to keep the contents. If I just select them and click the "Merge and Center" button - then I only get the contents of A1. How do I merge cells vertically and simply concatenate data? Best would be to have a line-break between the original cell contents. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Merge vertically ? | Excel Discussion (Misc queries) | |||
drag data vertically over hidden cells.. ignore hidden cells | Excel Discussion (Misc queries) | |||
Is it is possible to merge data from 2 cells into one? | New Users to Excel | |||
Merge cells with same data | Excel Discussion (Misc queries) | |||
how to merge mutliple columns vertically | Excel Worksheet Functions |