Results 1 to 2 of 2

Insert each line in a new row

Threaded View

  1. 05-24-2005, 10:42 AM #1
    delphi
    delphi is offline
    Registered User
    Join Date
    05-20-2005
    Posts
    4

    Insert each line in a new row

    I have an excel sheet that has following format

    row1: John Martin, Mary Katlin
    row2: Gary Bon
    row3:Mark Tiger, pat partion, Sally Gain, Todd Hinulo


    How do I convert this format so that each name will in in its own row? It is not only 3 rows but I have about 100 rows
    I like it to be like this:

    row1: John Martin
    row2: Mary Katlin
    row3: Gary Bon
    row4: mark Tiger
    row5: pat partion
    row6: Sally Gain
    row6: Todd Hinulo
    Last edited by delphi; 05-24-2005 at 11:45 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1