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.
 
Back
Top