I suppose you could try something like:
=IF(AND(ISNUMBER(SEARCH("P",A1)),NOT(MID(A1,SEARCH("P",A1)+1,1)="M")),"Material","")
I suppose you could try something like:
=IF(AND(ISNUMBER(SEARCH("P",A1)),NOT(MID(A1,SEARCH("P",A1)+1,1)="M")),"Material","")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks