Results 1 to 3 of 3

Thread: How to Split a Single Cell in Microsoft Excel 2007

  1. #1
    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.

  2. #2
    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

  3. #3
    Join Date
    May 2011
    Posts
    448

    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.

Similar Threads

  1. Need help to get single quote in every cell of Excel
    By Hache hi in forum MS Office Support
    Replies: 2
    Last Post: 23-02-2012, 01:17 PM
  2. Replies: 2
    Last Post: 17-02-2012, 01:00 PM
  3. How split a sentence into Word in Microsoft Excel
    By Tur^turro in forum MS Office Support
    Replies: 4
    Last Post: 15-02-2012, 05:57 PM
  4. How to get single apostrophe in cell of Excel
    By AsceTic! in forum MS Office Support
    Replies: 2
    Last Post: 15-02-2012, 05:06 PM
  5. How to fix maximum text in single cell of Microsoft Excel
    By Irritator in forum MS Office Support
    Replies: 2
    Last Post: 03-02-2012, 07:47 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,715,873.67926 seconds with 17 queries