The FIND function in Excel is a text function that allows you to find the position of a specified substring within a text string. It can be used to manipulate text data in various ways, such as extracting parts of a text string or replacing specific characters within a text string.
Syntax
=FIND(find_text, within_text, [start_num])
Arguments
find_text – the text string that you want to find
within_text – where you want to start searching
start_num – the position within “within_text” where you want to start searching for