I need to set up a macro that will split telephone numbers into the area code and the remainder.

I have a list of all available area codes - excluding the leading zero there are a mixture of 2,3,4 and 5 digit codes.

If the attached is used as an example, the phone numbers in col C have been split out into the area code in col D and the remainder into Col E as per the area code in col A.

I'm really not sure how to sort this one so if anyone can offer any help I would be really grateful! Thanks...

I have a list of all available area codes - excluding the leading zero there are a mixture of 2,3,4 and 5 digit codes.

If the attached is used as an example, the phone numbers in col C have been split out into the area code in col D and the remainder into Col E as per the area code in col A.

I'm really not sure how to sort this one so if anyone can offer any help I would be really grateful! Thanks...

## Comment