Alternatively toggle to the Home tab Editing. To find something press CtrlF or go to Home Editing Find Select Find. FIND will return VALUE if find_text is not found in within_text.
Before you can use the statistics functions in Excel you need to have all your data in an Excel range.
Searching for a specific range is more efficient and is always the best choice when appropriate. To find the number of the first Y in the descriptive part of the text string set start_num equal to 8 so that the serial-number portion of the text is not searched. This tutorial demonstrates how to use Excel FIND with four easy to follow examples and takes you step-. The Microsoft Excel FIND function returns the location of a substring in a string.