Split a cell into seperate rows

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Split a cell into seperate rows

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    New Member
    Join Date
    May 2002
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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

User Tag List

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