How to merge cells vertically - and keep all data

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.
 
D

David Biddulph

Don't merge cells. Merging causes many problems, as the archive of this
group will tell you.
If you want to concatenate, use the CONCATENATE function or the & operator.
If you want a line break, use CHAR(10)
Hence =A1&CHAR(10)&A2&CHAR(10)&A3
and format cells/ alignment/ wrap text
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top