Excel Find Function

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

Arguments:

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.

Important:

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.

Examples:

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

Share This Story, Choose Your Platform!

Leave A Comment