+ Reply to Thread
Results 1 to 3 of 3

filter numbers only

  1. #1
    Registered User
    Join Date
    10-08-2016
    Location
    PAKISTAN
    MS-Off Ver
    OFFICE 2016
    Posts
    74

    filter numbers only

    I have an excel sheet which consists of Phone /Address of the companies. The Phone numbers contained numbers along with "-" and ",". I wanted to filter numbers only.

    For example Cell "A4" should be included in the results as its consists of Numeric where as Cell "A2" should be exclude as its contained alphabets. A sample excel sheet is attached for reference.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-11-2021
    Location
    Netherlands
    MS-Off Ver
    365
    Posts
    1,386

    Re: filter numbers only

    What if you close this one with ctrl+shft+return? Then pull down for multiple results

    Please Login or Register  to view this content.
    This should work without using ctrl+shft+return

    Please Login or Register  to view this content.
    Last edited by JEC.; 12-10-2022 at 09:20 AM.

  3. #3
    Registered User
    Join Date
    10-08-2016
    Location
    PAKISTAN
    MS-Off Ver
    OFFICE 2016
    Posts
    74

    Re: filter numbers only

    Issue Resolved thanks for your help
    Last edited by asad.ermo; 12-10-2022 at 10:40 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Can i auto filter the numbers when i type? numbers
    By amrhosny in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-08-2019, 12:14 PM
  2. Filter between 2 numbers
    By Spikyd in forum Excel General
    Replies: 1
    Last Post: 05-06-2019, 02:39 AM
  3. Replies: 1
    Last Post: 12-12-2014, 06:46 AM
  4. [SOLVED] filter long numbers with only exact group of numbers
    By Zentiva in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-25-2013, 06:08 AM
  5. Advanced Filter or Autofilter to filter numbers?
    By odeno in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-08-2007, 12:12 PM
  6. FILTER - how to filter numbers ending with 00
    By jude1234 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-25-2006, 07:29 AM
  7. How can I filter odd numbers?
    By Davie in forum Excel General
    Replies: 3
    Last Post: 02-09-2006, 05:45 PM

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