I have a one long list of alphanumeric data approx. 3000 some rows in EXCEL 2010. Following is an example:
PP5690
AG8908
KJ3459
EVENTHORIZON
LISTnumber
UI3409
IL0965
I want to remove all rows that DO NOT conform to value like PP5690 i.e. First two characters are alpha and next four are numeric. The resulting list should look like:
PP5690
AG8908
KJ3459
UI3409
IL0965
Any help will be highly appreciated.
Al
PP5690
AG8908
KJ3459
EVENTHORIZON
LISTnumber
UI3409
IL0965
I want to remove all rows that DO NOT conform to value like PP5690 i.e. First two characters are alpha and next four are numeric. The resulting list should look like:
PP5690
AG8908
KJ3459
UI3409
IL0965
Any help will be highly appreciated.
Al