dreadnaught
Technical User
I have a work sheet with 5000 part numbers on it and I only want the part numbers that have 7 characters in it. How would I go about removing or sorting on this so I can delete out the other parts?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
sorting based on number of charicters 1
- Thread starter dreadnaught
- Start date
- Status
-
1
- #2
JVFriederick
IS-IT--Management
Write a formula to determine the length of the part number:
=LEN(A1)
Copy this formula for all 5000 records. Now sort both columns so the ones with length of 7 are together.
Do what you need to do from there.
=LEN(A1)
Copy this formula for all 5000 records. Now sort both columns so the ones with length of 7 are together.
Do what you need to do from there.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question