Excel Forum

Excel Magic Trick 530: Does Text String Contain Repair OR Rework? OR SEARCH ISNUMBER functions

See how to use OR, SEARCH, and ISNUMBER functions to see if the descriptions in a data set contain the test Repair or Rework. Check to see if one of two sub strings are within a larger test string.

Got a Question? Ask it Here in the Forum.