+ Reply to Thread
Results 1 to 7 of 7
  1. #1
    Registered User
    Join Date
    10-06-2009
    Location
    Spain
    MS-Off Ver
    Excel 2007
    Posts
    49

    Delete all non-numeric characters?

    Hello everyone,

    Is the a way to delete/remove al non-numeric characters from a document? Leaving just the numbers that apper in a document?


    Thanks in advanced,
    Elegidos (Spain)
    Last edited by Elegidos; 10-09-2009 at 12:40 PM.

  2. #2
    Forum Moderator shg's Avatar
    Join Date
    06-21-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2007
    Posts
    25,134

    Re: Delete al non-numeric characters?

    You can do a wildcard find and replace: find [!0-9] and replace with nothing.
    Microsoft MVP - Excel
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    10-06-2009
    Location
    Spain
    MS-Off Ver
    Excel 2007
    Posts
    49

    Re: Delete all non-numeric characters?

    What do you mean by wildcard? Do I have to enter [!0-9] in the "Find what" and in the "Replace with" leave it blank?


    Thanks again for the help

  4. #4
    Forum Moderator shg's Avatar
    Join Date
    06-21-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2007
    Posts
    25,134

    Re: Delete all non-numeric characters?

    Ctrl+H for Find and Replace, click More, tick Use wildcards, in Find what: [!0-9] , leave Replace blank.

    Click Replace All
    Microsoft MVP - Excel
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Registered User
    Join Date
    10-08-2009
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Delete all non-numeric characters?

    where is 'more' and 'wildcards' options in find and replace dialoge box?

  6. #6
    Registered User
    Join Date
    10-08-2009
    Location
    india
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Delete all non-numeric characters?

    Where is 'More' & Use 'wildcards' options in Find and Replace dialoge box?

  7. #7
    Registered User
    Join Date
    10-06-2009
    Location
    Spain
    MS-Off Ver
    Excel 2007
    Posts
    49

    Re: Delete all non-numeric characters?

    where is 'more' and 'wildcards' options in find and replace dialoge box?
    Press crtl-f or ctrl-h and there you will find the more button that will extend down with more options. And there you can find the wildcard option.


    Post solved. Thank you for the help .

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.2.0