Home » Ai Basics Digest » Need Excel Function to Filter Alpha Characters

Need Excel Function to Filter Alpha Characters

Robert Thorne • • 2 min read
Need Excel Function to Filter Alpha Characters

I have a column in excel file which is mix of set alphanumeric,number and alpha character , I want to filter out alpha character only. Need advise..

Column 1

100054
Mk1568
Un10008
Dngh
34677
Gopro
4

4 Answers

You can use the Advanced Filter with a Formula for a criteria

The formula must return TRUE or FALSE. This returns TRUE if there are no digits within the word:

Formula:  =MIN(FIND({0;1;2;3;4;5;6;7;8;9},A6&"0123456789"))>LEN(A6)

Setup

Robert Thorne
Author

Robert Thorne

Robert Thorne covers electric vehicle innovations, autonomous driving systems, global mobility trends, and automotive engineering developments.