How to parse the area code from a 10 digit telephone number?

Frank Felton

How to parse the area code from a 10 digit telephone number and use the area code in grouping reporting? I was using "Contains" to filter the data but the data changed that eliminated the parenthesis uniqueness(area code) in the data.

Parker Oxford

What format are the numbers in? Do you have any examples that we can use to derive a formula from? You'll likely need some version of the MID function to solve this but the format the numbers come in will determine that.

Frank Felton

Will this help?