Mae Smith

Greenhorn
+ Follow
since May 18, 2005
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Mae Smith

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
19 years ago