I have data that is imported from 3rd party software. Phone #s & fed. tax id’s have parentheses & hyphens in them. I need to remove the hyphens & junk from the data & return only the numbers.
How can I do this in Access? I’d like to use VB & automate the process.
Thanks for the help!
