Finding text in a cell and returning a value based on that text

[mctclover]

I'm trying to create a formula that will look at the cell containing
the text "B46292P" and if it finds the letter "P", return the word
"Paperback". Can anyone help me? If it helps, the P would always be in
the last position in the cell. However, sometimes, I would need to find
letters that would be in the last 2 positions in the cell to return a
value.

Thanks so much for any help!!

 

[P Sitaram]

=IF((LEN(A1)-LEN(SUBSTITUTE(A1,"P",""))>0,"Paperback","")

Sitaram

 

[John Bundy]

If you want it regardless of where the P is
=IF(FIND("p",A1)<>"","Paperback","")

 

[mctclover]

Thank you so much! This worked perfectly!

Lori

 

[Dave Peterson]

One more:

=if(countif(a1,"*p*")>0,"Paperback","not-paperback")

 

[Dave Peterson]

Just a note to the OP:

This will actually search for a lower case "p".

Change Find to Search if you want to find either P or p.

Or just make that "p" into a "P" if you want to match uppercase P.

ps. The =countif() suggestion is not case sensitive, either.