Hi All,

I have a number for example 33034P7 in cell A1

In B1 if the value in A1 has a P in it I want it to return the word "Finished Goods"

I have been experimenting with the below formula but can't get it to work. Any suggestions?

=IF(ISNUMBER(SEARCH("P",A1,)),"Finished Goods","")