Filter a column for any occurrence of a digit

Posted on 2014-08-19
Last Modified: 2014-08-19
Hello, I would like to filter a column I'm excel.  The criteria would be any digit.  How can I do this?  

Thank you
Question by:pdvsa
    LVL 27

    Accepted Solution

    I don't know any filter/wildcard method that will filter on cells that contain whole numbers (0 - 9).  But you can do this with a helper column that will identify if the original cell contains any digits.

    If your original data is in column A, add this array formula (using [Ctrl]+[Shift]+[Enter]) in an adjacent column and then copy it down as far as needed:

    You'll see TRUE or FALSE values:  TRUE means there is at least one digit in the original cell.


    Author Closing Comment

    perfect!  thank you very much.
    LVL 27

    Expert Comment

    by:Glenn Ray
    You're welcome.  I'm going to hang onto this formula; it might prove useful in data checks.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
    Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
    This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
    This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now