Use the SEARCH Function

If you're looking for some text string or other values within a cell you can use the Find feature in Excel. But what if you wanted to do this programatically and have it execute for every row without manual interventions. It can be done with a built in function called SEARCH...see the video to learn how to use the SEARCH function in Excel.