FIND Function In Excel
FIND function find the position of the word or a character for the given cell reference. Find function is a case sensitive. Example given below in image.
PARAMETER: = FIND ( FIND TEXT, WITHIN TEXT, START NUMBER)
FORMULA : = FIND(B2,A2,1)