find and replace troupble - need urgent help PLEASE

[RubyREDdymon]

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

 

[John Nurick]

Hi Ruby,

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