Search Cell for Specific Characters

  • I have a spreadsheet that contains a column with 4 numbers/characters. For example, "AB2C", "2222", "YYYY", etc. I want to check each cell in the column to see if the cell contains any of these letters: B,C,D,E,F,G,H,J,K,L,M,N,O,P,R,S,T,U,V,W,X. Is there a formula that can do that? If so, what do I need to do? Any help is greatly appreciated.

  • Re: Search Cell for Specific Characters


    If you list the values you want to check for in a separate column, then you can use a formula like:


    [COLOR="#0000FF"]=ISNUMBER(LOOKUP(2,1/SEARCH($H$2:$H$26,A2)))[/COLOR]


    where H2:H26 contains the list of characters to check for, and A2 contains the text string you want to search.

    Where there is a will there are many ways. Finding one that works for you is the challenge!

  • Re: Search Cell for Specific Characters


    Thanks, NBVC, for your response. I have a question for you. I tried your formula on the column, and it returned all values as true. Does your formula indicate whether or not one of the letters is in the cell?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!