Results 1 to 6 of 6

Split a cell into seperate rows

This is a discussion on Split a cell into seperate rows within the Excel Questions forums, part of the Question Forums category; I have a spreadsheet with several cells with more than one line of text in it. What can I do ...

  1. #1
    RC
    RC is offline
    New Member
    Join Date
    May 2002
    Posts
    15

    Default

    I have a spreadsheet with several cells with more than one line of text in it. What can I do to split each line of text into seperate rows?

  2. #2
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701

    Default

    Select the cell in question.
    Go to the formula bar and copy the contents (Do not just copy the cell).
    Select the cell where you want to paste and paste.
    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

  3. #3
    RC
    RC is offline
    New Member
    Join Date
    May 2002
    Posts
    15

    Default

    Thanks it worked, but how can i write a macro that will do the same to all the cells in a column and create another column with all the cells split out.

  4. #4
    New Member
    Join Date
    Jun 2002
    Posts
    12

    Default

    Have you tried selecting the entire column and then click on Data / Text to columns / Delimited and then only check the space box?

  5. #5
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701

    Default

    One question, are the unsplit cells only two lines long? What I mean is does the cell only have to be split into two columns or can it be split into more?
    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

  6. #6
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701

    Default

    If they only have to be split into two columns try the following code:

    First select the cells (in one column) that you want to split and then run the code.

    Code is very customizable, so post with comments.
    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com