1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

[SOLVED] Excel filter out junk question

Discussion in 'Business Applications' started by Streamlight, Sep 16, 2003.

Thread Status:
Not open for further replies.
Advertisement
  1. Streamlight

    Streamlight Thread Starter

    Joined:
    May 15, 2003
    Messages:
    73
    Hey,

    I have a long list of thousands of names and emails and there is some bad data in a bunch of the cells reading "::::" I need to filter this out or somehow erase all those cases. Doing it by hand is insane as there are thousands of them. I heard that filter could get rid of them but I dont know how to use it.. if anyone could give me a detailed way of getting ride of all these instances it would be amazingly helpful

    thanks
     
  2. cybertech

    cybertech Retired Moderator

    Joined:
    Apr 16, 2002
    Messages:
    72,115
    Two ideas you might try.

    You could sort the entire worksheet so you can easily delete the rows.

    You could use Edit, Replace and search for :::: and replace with nothing.

    :)
     
  3. Streamlight

    Streamlight Thread Starter

    Joined:
    May 15, 2003
    Messages:
    73
    wow, replace worked like magic. Thanks a lot.. yea, our programmer came up to me and wanted me to do it by hand.. Im an intern so i cant say no.. you just saved me a lot of pointless work. there are over 200,000 rows... thanks a lot
     
  4. cybertech

    cybertech Retired Moderator

    Joined:
    Apr 16, 2002
    Messages:
    72,115
    My pleasure! Happy to know my suggestion saved you so much tedious work.

    :D
     
  5. Streamlight

    Streamlight Thread Starter

    Joined:
    May 15, 2003
    Messages:
    73
    Oh it did, thanks again.. just one quick question though. How would I sort toe whole doc ?
     
  6. Streamlight

    Streamlight Thread Starter

    Joined:
    May 15, 2003
    Messages:
    73
    I found the sort option but I need to sort alphabetically but Im not sure how to do it..
     
  7. Streamlight

    Streamlight Thread Starter

    Joined:
    May 15, 2003
    Messages:
    73
    oh, select all then sort... got it
     
  8. cybertech

    cybertech Retired Moderator

    Joined:
    Apr 16, 2002
    Messages:
    72,115
    Choose the column you need to sort by and pick ascending or descending.
     
  9. Streamlight

    Streamlight Thread Starter

    Joined:
    May 15, 2003
    Messages:
    73
    thanks a lot cybertech.. big help
     
  10. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/165245

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice