find and replace troupble - need urgent help PLEASE

G

Guest

I need to search a phone number field and replace a normal phone number i.e. (999)999-9999 with just the numbers i.e. 9999999999. I need to do this using the find and replace in datasheet view of a table. I would really appreciate any help I can get with this ASAP... I know what to put in the find box, my trouble is what to put in the replace field.

Thank you soooooo much for any help!!!!
Ruby
 
J

John Nurick

Hi Ruby,

Do it in three goes. First search for ( and replace with nothing; then
replace ) with nothing; finally replace - with nothing.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

find and replace trouble - need urgent response please! 2
Removing Symobls from phone numbers 4
Find Phone Number in Database 1
Access And Phone Numbers 5
How to format a phone number in Excel 4
Reports and Phone Number Format 3
how do I get Contacts 2003 to format a phone number? 1
probably easy manipulation 1

Top