Joke Collection Website - Public benefit messages - How to quickly filter non-1 1 digit phone numbers?
How to quickly filter non-1 1 digit phone numbers?
Use function filtering.
Use function filtering to quickly filter phone numbers that are not 1 1 numbers. Enter the function formula =LEN(A2) in the cell on the right, and the number of digits will appear after the drop-down filling. Then sort the columns in ascending and descending order, and you can intuitively see that the data either shows the phone number of 1 1 digit or the missing phone number.
- Previous article:Sweet words that make girls happy.
- Next article:How to modify Changzhou provident fund reservation number online
- Related articles
- Parents' group health reminder SMS content
- Leader's birthday greeting man
- 52 cracked text messages
- Cold weather needs to care about greeting information.
- The phone can be connected, but the other party can't accept the message. Why is this?
- How long does it take to call if there is a problem after the national examination qualification review email is sent out?
- What kind of employee benefits does the enterprise provide during the Spring Festival?
- Why can't the express cabinet scan the code?
- What social software is popular abroad and what is the most commonly used social software for foreigners?
- What game made you forget to eat and sleep for a holiday? Why?