Extracting phone numbers which contain a certain area code

Occasional Visitor

Hi all, I'm trying to find a formula which will match and find the area codes listed on one worksheet with a list of phone numbers on another worksheet where the area code is contained within the phone numbers. I then need to extract the phone numbers with these area codes to another worksheet. Any help would be much appreciated. Thank you. 

0 Replies