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

Reply
 
Thread Tools Search this Thread
  #1  
Old 11-01-2012
Member
 
Join Date: Jan 2012
Posts: 41
How to Split a Single Cell in Microsoft Excel 2007

I need help to split single cell into multiple cell. I tried to use a script for the same which ended to a error.
Reply With Quote
  #2  
Old 11-01-2012
Member
 
Join Date: Jun 2011
Posts: 798
Re: How to Split a Single Cell in Microsoft Excel 2007

Use the white space (here) to describe your problem in more detail. Do you want to extract data from a single cell into two or more other cells. Instead of trying to split your cell G6 in two overlapping cells, you must try this out. This is just a example. Assum that there is data in reference cells.
  • Insert a new row 7
  • Merge A6 and A7, B6 and B7 ... F6 and F7, H6 and H7 ...
  • Distribute your data between G6 and G7 (unfused)
  • Select lines 6 and 7 and do Format / Alignment / Vertical / Centered
Reply With Quote
  #3  
Old 11-01-2012
Member
 
Join Date: May 2011
Posts: 446
Re: How to Split a Single Cell in Microsoft Excel 2007

You can not split a cell in excel, it's not like in Word.The only thing you can do is add a column in the cell and distribute the data.
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 Split a Single Cell in Microsoft Excel 2007"
Thread Thread Starter Forum Replies Last Post
Need help to get single quote in every cell of Excel Hache hi MS Office Support 2 23-02-2012 01:17 PM
How to combine text of multiple row in a single cell of Excel YajasK MS Office Support 2 17-02-2012 01:00 PM
How split a sentence into Word in Microsoft Excel Tur^turro MS Office Support 4 15-02-2012 05:57 PM
How to get single apostrophe in cell of Excel AsceTic! MS Office Support 2 15-02-2012 05:06 PM
How to fix maximum text in single cell of Microsoft Excel Irritator MS Office Support 2 03-02-2012 07:47 PM


All times are GMT +5.5. The time now is 05:38 AM.