FIND function in Excel returns the position (as a number) of the given string inside another string. FIND returns a #VALUE error if there is no match found.

Syntax of Excel Find Function

Here is the syntax of Excel Find Function.

=FIND (find_text, within_text, [start_num])


Excel Find Function


find_text : Sub string to find in another string or cell.
within_text: Actual string to find within.
[start_num]: Starting position in the text to search fro sub string. It is an optional parameter, the default value is 1.


Find function is Case sensitive.
This does not support wild card search.
#VALUE will be return if there is no match found.

Return value: Find functuion returns a number representing the location of find_text.


The following example shows how to use Find function in Excel. This will find a text in Cell A1 and print the posting of the find text i n Cell B1.

Find Function Example

Excel Find Function

Share This Story, Choose Your Platform!

Leave A Comment