excel 2010 - Filtering area codes and phone numbers

Filter > Custom Filter

Equals 732???????

Several options.

1. Create a new column, set formula to =Left(A1,3) (assuming the phone numbers are in column A and start in the first row, adjust if necessary) and drag down as far as necessary. Then you can filter on that column.

2. Using vba:

Range("YourRange").Columns(1).AutoFilter Field:=1, Criteria1:="=732*", VisibleDropDown:=False

Select allOpen in new window

Again this is assuming that the phone numbers are in column A (if not change .Columns(1) to the proper column index).
Range("YourRange") is a named range but you could use any range i.e. Range("A1:A250").

Similar to ThinkSpaceSolutions suggestion:

AutoFilter > Begins with 732

I tried "begins with 732" and "=732"  and got blanks as a result (i.e. nothing).