Excel 2003 Like Formula or Wild Char

[Zonie32]

Hello. I'm trying to figure out how to write IF the cell contains a "P" anywhere in the word, then I want it to show "IN" otherwise "OUT", ie;

PV8O - IN
P40 - IN
CXWP - IN
F40 - OUT
CXWF - OUT

Can someone help? I've been trying for a while now and just can't seem to get it. thanks!

 

[AnotherHiggins]

[tab][COLOR=blue white]=If(IsNumber(Search("p",A1)),"IN","OUT")[/color]

Note: Search is not case sensitive - Find is.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[Zonie32]

Oh, thank you! I've been trying different formulas all day and finally with your help this works just great. Thanks again!

 

[AnotherHiggins]

Glad to help


[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.