FIND Function Explained
The FIND function in Microsoft Excel is used to locate a character or a string of characters within a larger string of text. It returns the position of the character or string of characters within the larger string. It takes three arguments: the string to search for, the string to search in, and the starting position of the search.
FIND Function Syntax
FIND(find_text, within_text, [start_num])
- find_text: The text you want to find. It can be a number, text, or a cell reference.
- within_text: The text containing the text you want to find.
- start_num: (optional) The character position in within_text at which to start the search.