Excel FIND() Function

The FIND() function in excel finds one text value within another. It is a case-sensitive function.

Syntax

FIND (find_text, within_text, [start_num])

Parameter

find_text (required)- This parameter represents the text to find.

within_text (required)- This parameter represents the text to search within.

start_num (optional)- This parameter represents the starting position in the text to search. The default value is 1.

Category

Text

Return

This function returns a number representing the location of ‘find_text’ parameter.

Example 1

Objective: Find the position of first small "e" in corresponding Text cell

Text	Result	Formula
Laptop restarted	9	=FIND("e",A22,1)
Excel is wow!	4	=FIND("e",A23,1)
Superstore is closed	4	=FIND("e",A24,1)
90 Employees	10	=FIND("e",A25,1)

Example 2

Objective: Find out the 2nd occurrence of space” “ in corresponding cell

Text	Result	Formula
Ritu Sinha Bhist	11	=FIND(" ",E93,FIND(" ",E93)+1)

Related Topics

How to Alphabetize in Excel?

Alphabetize in Excel One of the reasons for Excel's widest popularity is its ability to swiftly and effortlessly sort data. Excel facilitates easy methods that alphabetically sort the lists of strings...

5 minutes read.

Excel Unique Values

The Unique function in Excel filters the list of unique values from the given data like range or array. The data presented is either number, text, date, time etc. This...

3 minutes read.

Count Cells with Text in Excel

Excel spreadsheets are widely used in many fields to store and analyze data. Usually, the cells present in excel are a combination of numbers and text. To perform the calculation...

3 minutes read.

Text to columns in Excel

Microsoft Excel is widely used in startups to large companies. The data are entered in required rows and columns, and sometimes the data entered in one cell needs to enter...

4 minutes read.

Excel TIME() Function

Excel TIME() Function The TIME() function in excel returns the serial number of a particular time. Syntax TIME(HOUR, MINUTE, SECOND) Parameter HOUR (required)- This parameter represents the hour for your time. MINUTE (required)- This parameter represents the...

1 minute read.

Excel WORKDAY.INTL() Function

Excel WORKDAY.INTL() Function The WORKDAY.INTL() function in excel returns a date before or after a specified number of workdays with custom weekend parameter. Syntax WORKDAY.INTL (START_DAY, DAYS,[WEEKEND],[HOLIDAYS]) Parameter START_DAY (required)- This parameter represents the initial date...

2 minutes read.

Trendline in Excel

A Trendline is a line imposed on a graph to predict the direction of the data. It connects the series of data together to showcase the data best fit. The...

3 minutes read.

Excel Ribbon Toolbar

Excel Ribbon/Toolbar How does a toolbar look like? The top section of an excel file is called a Ribbon or a toolbar. It has various commands which can be useful for us in our daily work....

6 minutes read.

Unique Values in Excel

The Unique function in Excel filters the list of unique values from the given data like range or array. The data presented is either number, text, date, time etc. This...

3 minutes read.

Excel File using Password

How to Protect an Excel File using Password? Nowadays Microsoft Excel is widely used by large organizations to small organizations for their personal and professional usage. They share files to various...

2 minutes read.

How to Make Use of the F-Test in Excel

Intro to F-Test in Microsoft Excel F-Test is primarily considered to be the essential tool of statistical in Microsoft Excel that, in turn, is used to do the hypothesis test with...

7 minutes read.

Converting Units in Excel

The numeric values present in Excel consist of various types such as constant, integer, decimal etc. For calculation purposes, the values present in the data need to be converted to...

4 minutes read.

Purpose of Randomize in Excel

Excel spreadsheets are used on a large scale for business and personal usage. It is used to store data, perform multiple calculations, make assumptions based on charts and graphs etc....

7 minutes read.

Excel Themes

Microsoft Excel contains various features to enhance the appearance of the worksheet like text color, font size and general outlook of the objects. The users are provided with multiple theme...

3 minutes read.

Excel SUBSTITUTE() Function

The SUBSTITUTE() function in excel substitutes/replaces the old text with the new text in a string. SUBSTITUTE function is used to clean data. This function is case-sensitive. Syntax SUBSTITUTE(Text, Old_Text, New_Text, [instance_number]) Parameter Text (required)- This...

2 minutes read.

Dependent Combo box in Excel VBA

Adding the particular dependent box in the created User form with the help of the Microsoft Excel VBA is considered essential and crucial in Microsoft Excel. Here, in this tutorial, we...

7 minutes read.

Excel COUNTIFS() Function

Excel COUNTIFS() Function The COUNTIFS() function in excel is used to count the numbers within a range that meet the supplied criteria. Syntax COUNTIFS (range1, criteria1, [range2], [criteria2], ...) Parameter Range1 (required)- This parameter represents...

1 minute read.

Row Difference in Excel

Microsoft Excel is used for multiple purposes in various organizations. It is a combination of numeric values, alphabets etc. To calculate data, the user organizes the data according to their...

5 minutes read.

Excel HLOOKUP() Function

Excel HLOOKUP() Function The HLOOKUP() function in excel is used to search a value in the topmost row of a table and then return a corresponding value in the same column for the specified...

2 minutes read.

Array Formula in Excel

How to use Array Formula in Excel? By default, Excel consists of various formulas for calculating the data. Among various formulas, the Array formula is a powerful one that is used...

8 minutes read.