LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 19
Default How to merge cells vertically - and keep all data

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merge vertically ? bbelly Excel Discussion (Misc queries) 9 April 24th 23 09:06 PM
drag data vertically over hidden cells.. ignore hidden cells Derwood Excel Discussion (Misc queries) 1 March 6th 08 10:59 PM
Is it is possible to merge data from 2 cells into one? norvesh New Users to Excel 2 October 1st 07 10:28 PM
Merge cells with same data Jithu Excel Discussion (Misc queries) 0 June 21st 07 02:30 PM
how to merge mutliple columns vertically techteacher Excel Worksheet Functions 0 March 10th 05 02:37 AM


All times are GMT +1. The time now is 12:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"