+ Reply to Thread
Results 1 to 2 of 2

Split contents of a cell and insert new rows to put the data

  1. 09-22-2013, 01:04 PM #1
    sbhattacharya99
    sbhattacharya99 is offline
    Registered User
    Join Date
    03-16-2012
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    15

    Split contents of a cell and insert new rows to put the data

    I would like to split contents of a cell and insert new rows to put the data

    Please see enclosed attachment for example.

    Thanks !!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-22-2013, 02:02 PM #2
    AB33
    AB33 is offline
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Split contents of a cell and insert new rows to put the data

    The code works on the sample, but if you want the output in a different sheet, I can adjust it.
    Attached Files Attached Files
    Last edited by AB33; 09-22-2013 at 02:23 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Split a cell of data into multiple rows
    By otterandrews in forum Excel General
    Replies: 4
    Last Post: 03-24-2013, 11:59 PM
  2. [SOLVED] Split data from one cell into two new rows
    By ports83 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-27-2012, 01:59 AM
  3. Split cell contents over multiple rows based on cell contents
    By naigy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-17-2011, 05:38 PM
  4. Macro to split a cell data into rows and copying other cells as it is in rows
    By shaan65 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-26-2010, 12:45 AM
  5. Macro to split a single cell data into rows and copying other cells as it is in rows
    By Pankaj Sonawane in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-25-2010, 07:09 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1