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.
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?
Re: Search Cell for Specific Characters
Scratch that. I made an error typing in the formula. Thanks for your help. :thumbcoo:
Don’t have an account yet? Register yourself now and be a part of our community!