FIND, SEARCH

Back to all functions

In this lesson, we’ll be taking a look at FIND and SEARCH, which find the position of a given string of text within another string of text. They are similar, but have one important difference.
Both functions consist of two arguments, and one optional one. The text that we’re looking for, where we want to search, and if we want, where in the text we want to begin counting.
We’ll start by typing Equals, FIND, the text we want in quotation marks, and where we want to search. The FIND function is case-sensitive, so we will get an error looking for an upper case S, so we’ll change it to lower case.
The first lower-case S is in position number 7.
We can use the third argument in the function, to start counting at position number 8 instead, which means that the next lower-case S is at position number 17.
The SEARCH function allows us to use what are called wildcard characters. For example, we can use the asterisk to search for the text ESY, and ISH, with any amount of characters in between.
Now, if we change the text in such a way that the function still applies, nothing is changed.
Note that the SEARCH function is case-insensitive.

Popular courses

The Excel Functions Guide

Deepen and develop your Excel Functions skills

Learn how to efficiently manage databases, clear text in cells, and retrieve values from other tables. The course also walks...

Excel Essentials

Get a better understanding of the Excel workflow

Learn to feel more comfortable in Excel. This course will help quickly develop your knowledge in Excel. Excel Essentials is...

Contact us for assistance in finding right course

Excel for your profession

The Excel course for Procurement and Logistic professionals

Excel for professionals working within procurement and logisticians

In cooperation with organisations and professionals within the industry, Learnesy have developed an Excel course that is adapted to those...

Looking for something custom made? Contact us and we will make sure to meet your requirements.

Contact