I have a list of parts numbers that I need to check is they are discontinued or not.
Example:
66122
66123
66042
DISC21010
66080
DISC20004
008Z
I need formula to determine if the values in the cell start with DISC, if so to place in an other cell next to it "Discontinued" and if not "OK"
I am having issue with using wild cards and not sure how?
I would appreciate it if anyone can help
Bookmarks