Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to Merge Cells vertically in Microsoft Excel without loosing the Data

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 11-01-2012
Member
 
Join Date: Jan 2012
Posts: 23
How to Merge Cells vertically in Microsoft Excel without loosing the 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.

Reply With Quote
  #2  
Old 11-01-2012
Member
 
Join Date: Jul 2011
Posts: 431
Re: How to Merge Cells vertically in Microsoft Excel without loosing the Data

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.
Reply With Quote
  #3  
Old 11-01-2012
Member
 
Join Date: Aug 2011
Posts: 539
Re: How to Merge Cells vertically in Microsoft Excel without loosing the Data

What I can offer is just concatenate but through a macro that loops through your first cabbage and combine each cell to the next, keeping both values. Another option would no macros, auxiliary concatenated in a cabbage with this formula: = B1 & "" & C1 stretching the rest of the auxiliary col. Then you subtract this cabbage and copy paste special, values only.
Reply With Quote
  #4  
Old 11-01-2012
Member
 
Join Date: Jul 2011
Posts: 632
Re: How to Merge Cells vertically in Microsoft Excel without loosing the Data

The procedure for joining two cells in Excel is very simple. Simply select all the cells you want to join (can be many, not necessarily two) and pressed the button on the top bar of the Combine and Center. In the next image I have marked with a red arrow to find it faster. If you do not have the shortcut bar, look in the menus. Once the cells selected, go to the Format menu, then Cells (or press Ctrl +1 and get the same result). To perform the reverse operation, i.e., disengage the cells, should select the combination of cells and click the same button again in the bar we used to join them. The same applies to those who have done from the Menu. Access format cell again and remove the tick box Merge Cells.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to Merge Cells vertically in Microsoft Excel without loosing the Data"
Thread Thread Starter Forum Replies Last Post
Creating preset of data in MS Excel 2007 cells Jolyn Chris Windows Software 1 15-02-2012 05:01 PM
How to renumber cells in Microsoft Excel Weslee MS Office Support 2 24-01-2012 05:25 PM
How to merge two cells without deleting data from the cell RaaginiO Windows Software 4 05-01-2012 04:44 PM
Where can I find excel style to get data input cells Krishnaraju Windows Software 5 06-07-2011 01:05 AM
Short cut to merge cells in Microsoft Excel Jesus2 Windows Software 3 24-11-2009 06:31 AM


All times are GMT +5.5. The time now is 03:52 PM.