FIND Function

The FIND function is used to find the position of a specific letter in the text.
Note: If the letter appears more than once in the text, then the function returns the position of the first occurrence of the letter.


=FIND (Letter to find, Text to be searched, Start Position)
Whereas the Start Position is the position of the text from where the function should search for the letter.
Ex: A text may contain 10 letters. However, we can set the start position as 5 - this means the function searches for the letter from the 5th position of the text.

Video Tutorial:

Let us find the position of the given letter in the text, using the FIND function, with the help of the below video

Learn MS Excel

Ask Questions

Ask Question