Hi I am a amateur into VBA Excel. Not doubt wasnt easy for me but i tried to use this forumlae for work.

Thus, would like to seek the help on the following work example which can be replaced by a VBA.
My intention is to expand the category to go beyond more than 7 types with the help of a VBA to formulae by cell:

Column "A" - Highlights of work issue
Column "B" - Category with formulae of "=IF(ISNUMBER(SEARCH("bubble",A2)),"Bubble on Tape",IF(ISNUMBER(SEARCH("particle",A2)),"Particle on Tape",IF(ISNUMBER(SEARCH("stain",A2)),"Stain on Tape",IF(ISNUMBER(SEARCH("u-shape",A2)),"U-shape bubble on Tape",IF(ISNUMBER(SEARCH("offset",A2)),"Tape offset",IF(ISNUMBER(SEARCH("winkled",A2)),"Tape Winkled","Others"))))))"

Attached is the excel.Work Example01.xlsx

Any form of help and assistance is greatly appreciated!

Thanks & Regards,
Hate0lif3