SCAN Function Explained
The SCAN function in Microsoft Excel searches for a specified string of characters within a larger string of text and returns the position of the first character of the specified string. It takes two arguments: text and find_text. The text argument is the string of text to be searched, and the find_text argument is the string of characters to be found. The SCAN function returns the position of the first character of the find_text argument within the text argument.
SCAN Function Syntax
SCAN(text, start_num, num_chars)
- text: The text string or cell reference containing the characters to be scanned.
- start_num: The position in the text string from which to start scanning.
- num_chars: The number of characters to scan.