Start_num is optional and defaults to 1. Below is the step by step instructions for accomplishing this. FIND Function in Excel.
Ok lets look at the FIND syntax then.
The IF function is used to run a logical test and react differently depending on whether the result is TRUE or FALSE. It will return to 9. To correctly use a FIND formula in Excel keep in mind the following simple facts. Instead of manually counting how often a certain value or number appears let Excel do the work for you.