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.
You can do a wildcard find and replace: find [!0-9] and replace with nothing.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
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
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
where is 'more' and 'wildcards' options in find and replace dialoge box?
Where is 'More' & Use '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.where is 'more' and 'wildcards' options in find and replace dialoge box?
Post solved. Thank you for the help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks