using MID to extract ( ) and area codes

[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: [phone]...[phone]...[phone],etc.). I can't seem to ge the MID function to remove the entries at all. Please help.

Thanks
Mae

[M Beck]

what is the "mid" function?

if your phone numbers are stored in strings, then you might want to look up the String class in the API documentation; there are some methods you might find useful in it. for example, indexOf() and substring() might come in handy.