Excel SEARCH() Function

The SEARCH() function in excel finds one text value within another. It is the same, unlike FIND() function, with the only difference that it in a case-insensitive function.

Syntax

SEARCH (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 a corresponding Text cell

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

Example 2

Objective: Extract the last name from the given cell without entering a number of characters manually

Text	Result	Formula
Rohan Malhotra	Malhotra	=RIGHT(E99,LEN(E99)-SEARCH(" ",E99))

Related Topics

Locate Maximum Values in Excel

Excel is a combination of numeric values and numbers. To retrieve the result, Excel provides various formulas and functions. Sometimes the user needs to find the largest value from the...

5 minutes read.

Check Marks in Excel

What is a Check Mark? Among various characters checkmark is one of the characters used to indicate that the item or product in the list is correct, chosen or selected. A...

5 minutes read.

How to generate random numbers in Excel

In this tutorial, we will discuss the following things in detail that are as follows: Introduction about Random Numbers used in Microsoft Excel. Discuss how to generate the Random Numbers in Microsoft...

6 minutes read.

Excel SEARCH() Function

The SEARCH() function in excel finds one text value within another. It is the same, unlike FIND() function, with the only difference that it in a case-insensitive function. Syntax SEARCH (find_text, within_text, [start_num]) Parameter...

1 minute read.

Blank cells in Excel

Microsoft Excel is spreadsheet software designed by Microsoft in 1987. It is used to perform arithmetic calculations in various fields like statistical, engineering and financial. Many times, we export data...

4 minutes read.

Insert Row in Excel

It was known that we have various multiple ways that are extremely helpful in inserting a particular row in the Microsoft Excel. And we have lots of shortcut options available...

6 minutes read.

Notes in Excel

Notes in Excel Notes are used to include additional information to the cell and explain formulas calculation, any modification made to the cell, providing necessary information on data that is entered or to provide any...

3 minutes read.

How to import Microsoft Access data into the Microsoft Excel

Microsoft Access is primarily considered vital and the primary tool for individuals who want to create and manage the respective type of Database efficiently. This tutorial will discuss how to import...

5 minutes read.

Excel Axes

What is Excel Axes? Axes are a horizontal or vertical line containing units of measure. There are two types of axes X and Y axes. X is a horizontal and Y...

3 minutes read.

Copying formula in Excel

Copy a formula in Excel While working with statistical calculations in Microsoft Excel, the user uses formulas to calculate the mathematical operations. Implementing these formulas manually for each data is a...

3 minutes read.

What is a name box in Excel?

The name box in Microsoft Excel specifies a name for a single cell or a table. The name box is present in the top left corner, left to the formula...

4 minutes read.

Text to Columns

Text to Columns This Excel feature is used to split the cell content name of one cell into multiple columns based on a delimiter, such as a space or a special character or based...

2 minutes read.

Charts in Excel

Charts Definition of Charts A chart is used to show numbers or data in a spreadsheet visually. It is the visual representation of your data. It is a tool that can be used in...

3 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 MINUTE() Function

Excel MINUTE() Function The MINUTE() function in excel converts a serial number to minute (0 - 59). Syntax MINUTE (SERIAL_NUMBER) Parameter SERIAL_NUMBER (required)- This parameter represents the date or time from which you want to extract...

1 minute read.

Nearest Multiple in Excel

In Excel, the values in Multiplication can be round up, down and to nearest Multiplication number using Excel default function. This makes the calculation to be performed in an easier...

3 minutes read.

Conditional Formatting in Excel

Conditional Formatting What are the conditional formats? Conditional Formatting is a tool that allows the user to format cells or range of cells based on the selected condition or given criteria. The formatting will...

4 minutes read.

Excel MATCH () Function

Excel MATCH () Function The MATCH () function in excel locates the position of a lookup value in a row, column, or table and returns the relative position of an item in an array. Syntax MATCH...

2 minutes read.

SUM Functions in Excel

The BODMAS formula plays a vital role in the concept of mathematics. BODMAS rule follows the Bracket of Division, Multiplication, Addition and Subtraction. This rule is followed for a correct...

6 minutes read.