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


excel workbook password removervba delete columnexcel charunhide column a in excel 2010sas sql interview questionsunprotect excel sheet using vbarange cells excel vbacalculator codes in visual basictimeline excel templatenew line in vbaunshare excel spreadsheetexcel formula sumifsexcel formulas iferrorvlookup examples in excelcountif function examplefor vba stepvba msgmicrosoft excel charts tutorialadvanced excel 2007 tutorial pdfhlookup excel functionvbscript to copy files from one folder to anotherloop until vbaexcel vba datediffvlookup formula explanationvba message boxvlookup formula explainedvbscript sql server connectionddl commands in sql with examplesexcel concatenate functionvba form comboboxcheck activexunprotect excel 2007highlight duplicates excel 2010excel option buttonapplication filedialogif isna vlookup functionmacro writing tutorialvba clear sheetunprotect excel 2010 workbook without passwordcommands of dbmsexcel remove charactersexcel vba integer rangeaccess vba while loopvlookup between two valuesexcel tick boxprotecting excel spreadsheetexcel vba font colorexcel hotkey switch sheetsexcel vba advancedadvanced excel vba trainingvb rename fileadvanced filter in excel 2013database interview questions and answers for freshershow to unhide columnsadodb recordset opengetopenfilename vbaexcel password templatevba insert rowshow do i unhide column a in excelselect rows vbawhat are activex controls in wordhow to create excel macrohow to insert a row on excelvba excel tutorial with example pdfproject status report ppt templateproject spreadsheet template excelexcel vba set cell colorsimple vbaexcel vba substitutelock excel worksheethow to send email using vba