Excel FIND and SEARCH functions with formula examples | Excel find position
ThetutorialexplainsthesyntaxoftheExcelFINDandSEARCHfunctionsandprovidesformulaexamplesofadvancednon-trivialuses.Inthelastarticle,wecoveredthebasicsoftheExcelFindandReplace[1]dialog.Inmanysituations,however,youmaywantExceltofindandextractdatafromothercellsautomaticallybasedonyourcriteria.So,letshaveacloserlookatwhattheExcelsearchfunctionshavetooffer.ExcelFINDfunctionTheFINDfunctioninExcelisusedtoreturnthepositionofaspecificcharacterorsubstringwithinatextstring.ThesyntaxoftheExcelFindfunctioni...
The tutorial explains the syntax of the Excel FIND and SEARCH functions and provides formula examples of advanced non-trivial uses.
In the last article, we covered the basics of the Excel Find and Replace[1] dialog. In many situations, however, you may want Excel to find and extract data from other cells automatically based on your criteria. So, lets have a closer look at what the Excel search functions have to offer.
Excel FIND functionThe FIND function in Excel is used to return the position of a specific character or substring within a text string.
The syntax of the Excel Find function is as follows:
FIND(find_text, within_text, [start_num])
The first 2 arguments are required, the last one is optional.
Find_text - the character or substring you want to find. Within_text - the text string to be searched within. Usually its supplied as a cell reference, but you can also type the string directly in the formula. Start_num - an optional argum...