Im trying to identify cells that contain certain text using isnumber. I have
a column (M) that contains UK postcodes such as ST6 2JH, DE22 1BH, YO18 5DS
and many more etc. By using =ISNUMBER(SEARCH("YO",M2)) I am able to find the
YO in cell N2 but I need to expand it to find other postcodes as well, e.g.
DE. Column N should be able to state "True" when DE or YO is identified.

Thanks in advance.

Try it like this:

=OR(ISNUMBER(SEARCH({"YO","DE"},M2)))

--
Biff
Microsoft Excel MVP


"Arceedee" wrote in message
...
Im trying to identify cells that contain certain text using isnumber. I
have
a column (M) that contains UK postcodes such as ST6 2JH, DE22 1BH, YO18
5DS
and many more etc. By using =ISNUMBER(SEARCH("YO",M2)) I am able to find
the
YO in cell N2 but I need to expand it to find other postcodes as well,
e.g.
DE. Column N should be able to state "True" when DE or YO is identified.

Thanks in advance.

You can list as many as you'd like inside of an OR listing:

=IF(OR(ISNUMBER(SEARCH("YO",N2)),ISNUMBER(SEARCH(" DE",N2))),"TRUE")

Just slip in ans many ISNUMBER entries into the OR array as you'd like. If
any of them hit, you get a TRUE.
--
"Actually, I AM a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"Arceedee" wrote:

Im trying to identify cells that contain certain text using isnumber. I have
a column (M) that contains UK postcodes such as ST6 2JH, DE22 1BH, YO18 5DS
and many more etc. By using =ISNUMBER(SEARCH("YO",M2)) I am able to find the
YO in cell N2 but I need to expand it to find other postcodes as well, e.g.
DE. Column N should be able to state "True" when DE or YO is identified.

Thanks in advance.