Need excel function to filter alpha characters

Question

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

Solution 1

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

Results

You could also use a simple filter:

• Enter the above formula in B6
• Fill down as far as needed
• Filter on the Contents = TRUE

Solution 2

A simple way is to use =ISTEXT(somevalue) in a new column and filter for true.
You can do the same with =ISNUMBER, =ISBLANK, etc.

Example:

Comments

[Admin]

What have you tried? Where did that get you? You've given your input data but what is your expected output?

[Admin]

I need to filter out only alpha character. outputs-dngh gopro

[Admin]

I used below. =ISNUMBER(SUMPRODUCT(SEARCH(MID(A1,ROW(INDIRECT("1:"&LEN(A1)‌​)),1),"0123456789abc‌​defghijklmnopqrstuvw‌​xyzABCDEFGHIJKLMNOPQ‌​RSTUVWXYZ")))

[Admin]

What is the exact issue with your formula?

[Rajesh Sinha]

To use the Function to filter String,, =ExtractLetters (string to Xtract) ☺

[Rajesh Sinha]

I'm new to the Super User, could you please tell me the reason behind my code is been edited.

[Ramhound]

The code was not formatted. The alternative, to improving the answer, is to delete an unformatted answer.