How to filter all mobile phone numbers in a certain city in excel

How to filter all mobile phone numbers in a certain city in excel:

First, select the numbers in excel Sorting can be done in ascending or descending order, but the order must be in order.

Next, go to Baidu to search for all the mobile phone number segments in the city you want to filter, and put them into an excel. Here is an example.

Search each number segment in the excel to be filtered in turn. When the corresponding data is filtered, since the sorting process has been done, it is easy to find the numbers together.

After finding the numbers in the same segment, mark them with different colors.

Repeat the third step in sequence until all number segments have been found, that is, the screening of all numbers in a certain city is completed.

For more Excel-related technical articles, please visit the Excel Basic Tutorial column!

The above is the detailed content of How to filter all mobile phone numbers in a certain city in excel. For more information, please follow other related articles on the PHP Chinese website!