FIND Function in Excel

Home/Excel Formulas/FIND Function in Excel

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.

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates


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



Related Resource External VBA Reference
Excel VBA Reference Project Management Reference
VBA Reference:
Excel Reference:
By |June 15th, 2013|Excel Formulas|0 Comments

About the Author:

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


Related pages


sql sas tutorialremove duplicate cells in excelvba cutexcel 2007 listboxexcel 2007 protect workbookdml sql commandsvba xlsproject timelines templatessort order sqlvba instr syntaxexcel charts tutorialexcel widgetsexcel pivot table referenceremove duplicate in excel 2003microsoft excel macro programminghidden columns in excelcombobox in vba excelvba sheet protectionvlookup in excel 2007 formulaexcel macro delete columnpaste in vbavbscript sql server connection stringexcel advanced macrospaste values vbalearn excel vlookupfind duplicates in excel spreadsheetvba excel 2007 tutorialsum if examplevba operatortechnical aptitude questions and answersaccess vba listboxoffset function excel 2013global variable vbadelete blank rows excel 2010address vba excelexcel vba pivotexcel logic formulassyntax bold fonthide rows excelexcel macro break loophow to write a macro in excel 2007delete duplicates in excel columnddl and dml queriesexcel formula to check for duplicatesfile exists vbavba code to save excel fileadodb.connection openexcel test for empty cellvba iserrorexcel vba language referenceexcel hyperlink functionvba excel 2003excel workbook protectionexcel formulas and examplesadding macro to excelswot templates for wordadvanced excel pivot tablesms excel formulas 2007how to use the match function in excelmicrosoft office invoice templates for excelvba tutorial excelrun macro vbaexcel vba application.runopen xml file in excel 2010excel color cell formulaunlock password protected excelcells.find vbaexcel combo box propertiesunlocking excel filesexcel vba named rangeisna functionexcel reverse vlookupexcel task tracker templatevb 6.0 interview questionstechnical interview questions for freshersvba paste range