How to use the SEARCH function in Excel

How to search for specific data in Excel? Can I see some formula examples? How to find text in specific cells? And what's the difference between FIND and SEARCH? No worries, Ted Jordan is here to help!

The SEARCH function returns a number, corresponding to the position of the 1st character of the searched term within a text. It can be used for various reasons.

The function has 2 required arguments and 1 optional (start_num).
Syntax of the SEARCH formula: =SEARCH(find_text,within_text,start_num).

find_text – the text you want to find. It has to be within “”.
within_text – the text in which you want to search for find_text.
start_num – the position number you want the search to start from.

– You can use wildcard characters in the find_text argument. A question mark (?) will search for any single character and an asterisk (*) will match any sequence of characters.
– If you leave the start_num argument empty, SEARCH will start searching for find_text from the first character within within_text.
– If the find_text argument is not found, an error value will appear: VALUE!.
– The SEARCH function is not case sensitive in MS Excel: it does not make any difference between lowercase and uppercase letters.
– If searched characters appear several times within the within_text argument, the SEARCH function will not analyse find_text after the 1st result.

Use of the SEARCH function – Specific word

In this example, we want to extract all the email addresses containing the domain “tedjordan.org”. All cells resulting in positive numbers confirm the presence of the searched text.

Use of the SEARCH function – Wildcard characters

In this example, let extract all products available in specific sizes (not in unique size) using the wildcard character *; find_text is “size”. All cells containing positive numbers confirm the presence of a specific size reference.

Use of the SEARCH function – From a specific position

We want to find all references mentioning sizes in 40s. If we don’t specify the start_num,  results will be incorrect because 40s numbers can be found at the beginning of some references.
find_text “4?” so sizes not starting with 4 will be excluded (as per row 5).

If you want to replace ugly error values while using the SEARCH formula in Excel, combine it with IFERROR!

We want to extract all references mentioning specific sizes; to change VALUE! errors, we use the IFERROR function by replacing any error values by “Unique size”.

SEARCH and FIND functions work the same way but SEARCH is not case sensitive while FIND is.

Now, you know how to use the SEARCH function in Microsoft Excel!

Join our Course now to discover more tips and tricks about MS Excel!

Advertising
Analytics

Categories

AllAdvertisingFormatsPlatformsKPI'sAd News
What is Programmatic Advertising?

What is Programmatic Advertising?

Understand what programmatic advertising is and how it works to increase your ROI and become a programmatic specialist.

Read More
Programmatic Advertising: What is a DSP?

What are DSPs?

A DSP is a great tool to use but what does DSP stand for in marketing? What are some Demand-Side Platforms examples? Today, we answer your questions!

Read More

Best DSPs for Programmatic Advertising

Ted Jordan shares his list of best DSPs for Programmatic Advertising so you don’t have to lose time searching the internet to find the right Demand-Side Platform for your campaigns.

Read More
Programmatic Advertising: What is a SSP?

Supply-Side Platforms (SSPs) Explained

SSPs basics in advertising: learn what Supply-Side Platforms are used for and who use them. Get familiar with more programmatic advertising technical terms.

Read More

What is O&O Advertising?

Discover one more important jargon term used in Programmatic Advertising: O&O advertising. Get familiar with O&O formats and advantages.

Read More
Programmatic: Pixels in Advertising 101

Advertising pixels: types, pros and best practices

Learn the basics of Programmatic Advertising with Ted Jordan! Today, we explain what a pixel is in advertising with simple words and expertise. Ready to learn?

Read More

Categories

AllFunctionsToolsShortcut Keys

How to change shapes in Excel column charts

Learn how to easily change the columns shape in your Excel charts so your colleagues and customers will remember your impacting graphs.

Read More

How to use the LEFT, RIGHT and MID functions

Learn how to extract text in Excel with the LEFT, RIGHT and MID functions. Plenty of examples to learn from and functions are explained with simple words. If you start...

Read More

Excel IF statement: how to use it for 3 conditions

Learn how to use the Excel IF statement with multiple conditions and combine it with OR and/or AND functions!

Read More
Navigating with Tab, Enter, and Shift Key on Excel.

How to move between cells when arrow keys are not working (Excel)

Learn how to move between Excel cells without using your mouse or arrow keys. Discover more shortcuts and tricks below!

Read More

How to use the IFERROR function (Excel + Google Sheets)

Discover how to use IFERROR in Excel or in Google Sheets in 4 easy steps! No more errors on your documents or dashboards with IFERROR.

Read More
Cope Paste Options on excel with shortcut keys

Copy paste values like a pro! (Excel+Google Sheets)

Copy and paste values (not formulas) using shortcut keys in Excel or Google Sheets! Learn how spreadsheets professionals do it within seconds and become one of them. Save time now...

Read More