I have a huge file containing phone numbers where all unwanted characters like paranthesis, spaces, periods, and dashes need to be removed. Is there a way to do this in VBA? Right now I am using the functions Left$, Right$, and Mid$ to remove the characters (and place the numbers back together), but any of these characters could be in different places within the phone number string. My If Elseif statement is getting really long...
Any help in greatly appreciated!
Thanks!
Any help in greatly appreciated!
Thanks!