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

Excelx.com is a Excel Blog by PNRao to provide latest tips of Excel and help you to Quickly Learn and up-to date with Excel Concepts. We help you to know – how to do things in Excel with Clean and Easy Excel Tips, Shortcuts, Reference, Tutorials and New and Quick Tricks and Methods.

We Provide Free Online Tutorials, Formulas, Templates, Dashboards and Macros to excel in Microsoft Excel. We cover basic to advanced concepts and share creative ideas, Excel tips and Shortcuts with Related Example Files. You Can refer verity of examples covered on latest tools and techniques in Microsoft Excel Applications.

Related Posts