• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Format to be used to find only the cell value with alphabet in a column

Tharabai

Member
Hi,

I want to filter the values which are alphabet.

If I use if(not (isnumeric) option it also takes up the if the value is say 201 2

I tried to use (Isalphabet) option.. but its not working.

can anyone suggest me the format to be used.
 
Still am getting the same results. ex, 201, 2012, 2013, 201 3, 203 3, ADD, Sub

out of the above I need to put values only for the alphabets (ADD,Sub)
 
Back
Top