What is the use of FIND function?

FIND Function in Excel returns the location or position of a sub-string in a text string.
Note:
1. The find function is case-sensitive.
2. Search & Find performs the same task, But find is case sensitive.

What is the syntax of FIND function?

FIND Function in Excel Syntax

FIND(find_text, within_text,

[start_num])
Where
find_text : The substring that you want to find.
Within_text : The string containing the text you want to find.
Start_num: It is optional. The character at which to start the search. If omitted, this takes on the default value of 1

Note:
1. If find_text does not appear in within_text, FIND and FINDB return the #VALUE! error value.
2. If start_num is not greater than zero, FIND and FINDB return the #VALUE! error value.
3. If start_num is greater than the length of within_text, FIND and FINDB return the #VALUE! error value.

FIND Function in Excel – Examples

FIND Function in Excel Examples

Premium Project Management Templates

50+ Professional Project Management Templates!

A Powerful & Multi-purpose Templates for project management. Now seamlessly manage your projects, tasks, meetings, presentations, teams, customers, stakeholders and time. This page describes all the amazing new features and options that come with our premium templates.

PREMIUM TEMPLATES
LIMITED TIME OFFER
ON SALE80% OFF
BROWSE ALL TEMPLATES

50+ Project Management Templates Pack

Excel PowerPoint Word

VIEW DETAILS

Ultimate Project Management Template – Advanced

Excel Template

VIEW DETAILS

ULTIMATE PROJECT MANAGEMENT TEMPLATE

Excel Template

VIEW DETAILS

20+ Excel Project Management Pack

Excel Templates

VIEW DETAILS

20+ PowerPoint Project Management Pack

PowerPoint Templates

VIEW DETAILS

10+ MS Word Project Management Pack

Word Templates

VIEW DETAILS

By Published On: June 15th, 2013Categories: Excel FormulasTags:

Share This Story, Choose Your Platform!

About the Author: Valli

Excel VBA Developer having around 8 years of experience in using Excel and VBA for automating the daily tasks, reports generation and dashboards preparation. Valli is sharing to helps us automating daily tasks.

Leave A Comment