Find the letter’s position in a text.
The Excel FIND function displays the numerical location of the character in a given text. The starting position of a String can change based on the third argument [Start_num].
For example, to find the 2nd occurrence of 8, =FIND(8,128128,4) returns 6, start finding 8 from 4th digit that returns 6, i.e., 6th position in the figure.
= FIND(find_text, within_text, [start_num])
find_text – The character to find
within_text – The string containing the character
start_num [Optional] – Specifies the character to start the search.
The boolean result (True or False)
- In FIND function, the first character in the within_text argument is character number 1 (default position).
- The FIND function is case sensitive and does not allow wildcard characters.
- Use the SEARCH excel function if a user wants to perform a non-case-sensitive search and enable wildcard characters.
The FIND function returns the #VALUE! error value in case
- start_num is not greater than zero
- start_num is greater than the length of within_text
- find_text does not appear in within_text
Note: start_num [Optional] is important to return the position based on occurrence of the character.