+ Reply to Thread
Results 1 to 3 of 3

Deleting Unnecessary Lines

  1. #1
    Registered User
    Join Date
    10-25-2011
    Location
    Virtual
    MS-Off Ver
    Excel 2010
    Posts
    4

    Deleting Unnecessary Lines

    I've got a dumped list of lines in an Excel worksheet that looks like this:

    Rhonda Johnson
    3487556...
    $$18756
    Thomas Nichols
    1456522...
    $$21354
    Andrea Mirandez
    3454309...
    $$19876

    I need a macro which I can run which will delete the 2nd and 3rd lines of this file (up to 4000 lines) down to the end of the listing. Basically, I want to KEEP the names, and delete everything else. The pattern stays consistent, but I'm not sure how long the file will be each time it dumps. I've seen macros that delete alternate lines from the bottom up, so the steps needed to determine the total number of rows in this file would be great too!

    Can anyone help?

    THANK YOU!

  2. #2
    Valued Forum Contributor
    Join Date
    04-30-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    547

    Re: Deleting Unnecessary Lines

    Why don't you just sort the data? Numbers and letters will show in different places and you can then just delete the rows with the numbers.
    Like a post? Click the star below it!

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,457

    Re: Deleting Unnecessary Lines

    One way:

    Please Login or Register  to view this content.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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