I have column B filled with data that was delineated from extended raw information to now contain no more than 5 characters. After delineation the data now has values I want to keep and random pieces of text and numbers that I want to delete. The values i would like to keep will always be between 4 and 5 characters long. More specifically, I would like to keep any data that has numbers between 4 and 5 digits long, but some of the random 4 digit numbers have random letters following (3128t, 3244a, 1984g) and I would like to keep these values too. I assume it will require a filter using ####, #####, ####? or something to that affect. Any help would be greatly appreciated.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Delete Rows Not Containing Assorted Values
- Thread starter Perodin
- Start date
