To figure out the number of characters that need to be extracted to get the first name the formula uses the FIND function. Open the Find and Replace dialog by pressing the shortcut key Ctrl F. The FIND function is case-sensitive.
The FIND function below finds the string ro at position 4.
After checking this radio button. The dialog box takes care of the syntax such as placing comma separators between arguments and surrounding text entries in quotation marks. FIND will return a VALUE error if find_text is not found in within_text. With the COUNTIF function Excel can count the number of times a word or number appears in any range of cells.