Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel 2003 Like Formula or Wild Char

Status
Not open for further replies.

Zonie32

Technical User
Jan 13, 2004
242
US
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!
 
[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.
 
Oh, thank you! I've been trying different formulas all day and finally with your help this works just great. Thanks again!
 
Glad to help
[cheers]

[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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top