Hello All,
I'm new to this forum and would like to know how to remove the ( ) and area code from phone numbers and place them in a different. I have a list of about 1000 with phone numbers from all over the US. This list phone number column migh look something like this: (503)546-0998...(601) 630-4568...(704)567-0024,etc.). I can't seem to ge the MID function to remove the entries at all. Please help.
Thanks
Mae
