R
RSunday
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.
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.