+ Reply to Thread
Results 1 to 4 of 4

Selecting letters/characters/numbers separately for a filter

  1. #1
    Valued Forum Contributor WasWodge's Avatar
    Join Date
    08-02-2010
    Location
    Hampshire,England
    MS-Off Ver
    Office 365 and Office 2010
    Posts
    882

    Selecting letters/characters/numbers separately for a filter

    Hi there, does anyone know if there is a method to filter by characters/letters (or it would suffice to filter only by numbers).

    To explain the situation I have a sheet that is created via a macro from a text file but before I add a formula to the sheet (involving a lastrow code) I need to take out quite few rows of needless text i.e. headers, page numbers, file details, dotted lines from where the page breaks were on the text file etc. to cut down the rows of calculation. Obviously the number of rows varies with each load of a new text file.

    Now what I do have is a column (C) where all the rows I need to keep are a numeric value and all the lines I need to lose are either characters or letters.

    I can apply an autofilter for each different character/word/partial word but there are a fair few I would need to put in so I was wondering if there is already a method in excel for selecting letters/characters/numbers separately to use with a filter.

    Please note that it needs to be added to a macro and needs to work in Excel 2003.
    Last edited by WasWodge; 04-10-2011 at 06:50 AM.
    If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved

    Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,480

    Re: Selecting letters/characters/numbers separately for a filter

    If column C contains number only cells you can use a temporary helper column.

    Please Login or Register  to view this content.
    If this does not work you will need to post example workbook.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Valued Forum Contributor WasWodge's Avatar
    Join Date
    08-02-2010
    Location
    Hampshire,England
    MS-Off Ver
    Office 365 and Office 2010
    Posts
    882

    Re: Selecting letters/characters/numbers separately for a filter

    Cheers Andy, the code works for my purposes. I have to amend it as the helper column will have to be column M but I see the idea with the code so I should be able to manage that.

    Thanks for your help

  4. #4
    Registered User
    Join Date
    06-19-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    5

    Re: Selecting letters/characters/numbers separately for a filter

    I have almost the same issue but my sheet has part numbers and titles (letters) in column "A", in their own cells. I want just the titles to be moved to column "C".

+ 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