Find and Replace Question

[ZanyJanie]

I'm importing a number of text file into an access table and I've got a problem with inconsistant data formats within a phone number field. Below are a few examples of the data I'm trying to clean up.

(xxx) xxx-xxxx
xxx-xxx-xxxx
xxx xxx-xxxx

What I need is some VBA code that will find and replace all parenthesis, dashes, and spaces with a null character. Once I've got a consistant 10 character field, I can use a mask to display the data in a consistant format.

Can anybody help me with this code?

Thanks

 

[Jack Cowley]

I think this is what you are after...

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q138774

 

[ZanyJanie]

Thanks Jack ... That did the trick!
Jane