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.

John Bundy wrote:

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

--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

wrote in message
oups.com...
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!!


--

Dave Peterson