+ Reply to Thread
Results 1 to 2 of 2

Split one cell value into Rows

  1. 05-08-2014, 09:15 AM #1
    araviintl
    araviintl is offline
    Registered User
    Join Date
    05-08-2014
    MS-Off Ver
    Excel 2003
    Posts
    9

    Lightbulb Split one cell value into Rows

    Hi

    NEWBIE isnt what i can describe myself. May be a new born with no knowledge whatsoever.
    This might look simple and dumb to many but i`m having hard time figuring this out.

    I have got one column in which each cell has the complete data for the entire row.

    I would like to split the data in one cell into the same row.

    Need HELP !

    Got about 4000 records like it.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-08-2014, 01:31 PM #2
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,984

    Re: Split one cell value into Rows

    I'm not 100% sure what you want, but I hope that this is (I got hooked and spent an hour playing with it :-) ).
    Attached Files Attached Files
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    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] VBA Split Cell Contents to New Rows & Copy Cells containing single values to the new rows
    By jaimelwilson in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-14-2017, 05:30 PM
  2. Split cell into multiple rows
    By lando99 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 09-20-2012, 04:36 PM
  3. split the text in a cell into rows
    By rrakkki in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-13-2011, 11:23 AM
  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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1