Searching for letters in numbers again...

Hi All,

I have a number that goes 12824PM12. The PM stands for material so I have a formula that looks for the PM and returns the word "material".

That works fine.

I also have numbers with just P in it, for example 1234P5

I wanted to use the same formula to look at the cells with just P in and not PM but it doesn't seem to work.

The formula I use to look for PM is

=IF(ISNUMBER(SEARCH("PM",G2)),"Material","")

By changing the PM to P it will look at everything with a P. How do I get it to ignore a cell with PM in it?

I suppose you could try something like:
=IF(AND(ISNUMBER(SEARCH("P",A1)),NOT(MID(A1,SEARCH("P",A1)+1,1)="M")),"Material","")