find and replace troupble - need urgent help PLEASE

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
Find Phone Number in Database 1
Removing Symobls from phone numbers 4
Access And Phone Numbers 5
Reports and Phone Number Format 3
How to format a phone number in Excel 4
probably easy manipulation 1
Formatting Phone Numbers 1

Back
Top