+ Reply to Thread
Results 1 to 6 of 6

need to split cells into rows

  1. #1
    Registered User
    Join Date
    10-23-2011
    Location
    Ohio
    MS-Off Ver
    Excel 2003
    Posts
    11

    need to split cells into rows

    Hello,

    I need to split colum F, they are comma delimited, I can use the text to column command but it puts the value into a new column. I need it in the row along with its proper easting and northing values. So it should insert a new row and copy the A, b, and C column and the split cell value.

    attached is an example of the problem.
    Attached Files Attached Files
    Last edited by patchypich; 10-24-2011 at 10:26 AM.

  2. #2
    Forum Guru
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2003
    Posts
    4,168

    Re: need to split cells into rows

    hi, patchypich, please check attachment, run code "test"
    Attached Files Attached Files
    Last edited by watersev; 10-24-2011 at 08:51 AM.

  3. #3
    Registered User
    Join Date
    10-23-2011
    Location
    Ohio
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: need to split cells into rows

    Hi Watersev,

    it works on the orignial.xls but when I goto run it on my other books it gives me error. i attached the file.
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2003
    Posts
    4,168

    Re: need to split cells into rows

    please check attachment, blanks in 6th column were not accounted for
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    10-23-2011
    Location
    Ohio
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: need to split cells into rows

    Wonderful! Thank you so much again.

  6. #6
    Forum Guru
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2003
    Posts
    4,168

    Re: need to split cells into rows

    is it right to miss rows empty in column 6? If it's not, try this
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1