Joke Collection Website - Public benefit messages - How to filter mobile phone numbers with EXCEL: Mobile phone numbers are all 1 1 digits. What can I do to screen out the number of this segment: 1393704?
How to filter mobile phone numbers with EXCEL: Mobile phone numbers are all 1 1 digits. What can I do to screen out the number of this segment: 1393704?
First, it can be sorted.
Second, you can customize the filtering, that is, menu-data-filtering-automatic filtering.
At this point, the first cell in the column where the mobile phone number is located will have an automatic filter button with a black inverted triangle.
Click, and select "Custom" from the pop-up options.
In the pop-up dialog box
Select "From" as the option on the left.
In the box on the right, enter 1393704.
Be sure.
- Related articles
- Matters needing attention in cleaning and maintenance of Daikin air conditioner
- What's the phone number of Mianyang traffic police team?
- The person you like sends you a message asking you not to contact again. He says he has a girlfriend. What would you do?
- Diary Day Tian Mi Zhu Yu
- Bank of Communications Spring Festival holiday arrangements
- When can I find the results of the second batch of volunteer recruitment for undergraduate students in Yunnan?
- How to remove the verification code function of ECSHOP JD.COM V4.2 from the user registration page (PHP)?
- How does China Eastern Airlines inquire about the reserved air tickets?
- Lovers' thoughts and wishes
- What is the psychology of people who love to change their avatars?