Thursday 27 February 2014

An alternative to the FIND function

By , Director, Naturally Sales Ltd.

Today, we'll look at a very function: SEARCH. The crucial difference, is that FIND is case-sensitive whereas SEARCH isn't. The structure is the same as FIND, so it works like this:




If A1 contains the word "Date", this will return a "3", as "t" is the third character in the word "date".

So remember: they do the same thing, but FIND is case-sensitive and SEARCH isn't.