FIND() vs SEARCH() Function in Excel

200+ Video Tutorials - 200+ Downloadable Excel Reference Files - 50+ Hours of Content

The differences between FIND() and SEARCH() and when to use these functions in Excel - these functions are similar but have important differences.

The FIND and SEARCH functions in Excel are very similar and perform the same task, but in slightly different, but very important, ways.

This tutorial goes through a full explanation of how to use the FIND() and SEARCH() functions and then compares the two functions, showing you the differences and when you should use one vs the other one.

The examples in this tutorial include:
- Performing case-sensistive searches.
- Performing wildcard searches.
- Equalizing cases so that you can use either function (FIND or SEARCH) regardless of the contents of the cell or search value.

I hope you enjoy this tutorial!

#excel #tutorial #howto

[exlrin]

Thanks for the video, Very Nice!

QQ: Which Formula would work when you are searching for GE in GE but not GE in MGEX?

[DaddyBear]

This is VERY useful. I've just found additional results in a large database that had previously been missed by swapping to the search function.

[IvanCortinas_ES]

A great explanation. Thank you for telling us the examples with wildcards!

[wayneedmondson]

Great advice! Easy to make a mistake if not well understood between the two functions. Thanks for the lesson. Thumbs up!!

[TeachExcel]

200+ Video Tutorials - 200+ Downloadable Excel Reference Files - 50+ Hours of Content

[nadermounir]

Well explained thank you for your hard work

[jimcrain]

BTW: if you need to search for a ~, you must use ~~ in your find_text string. It happened to me…

[DormantRV]

What I want to find the position of space before the word "Value" ....

[nairobi]

I need to search starting from right to left... is this even possible?

[darrylmorgan]

Great Tutorial Really Well Explained..Thank You Sir :)

[sureshlovevanshi]

Hello there...is it possible to run a macro just after power query refresh automaticaly ...Data Refresh then Macro Run ...

[lisaramaha]

What to do if there is multiple same data in same column, how to get both data Position number

[jacobchama]

I HAVE A HUGE LIST OF NUMBERS AND I NEED TO FIND 191 FROM THE LONG LIST PLEASE HELP

[MertBayramoglu]

You talk too much nonsense. The 3 minute video was 11 minutes. An expert is someone who describes an event simply and in a short time.

[keithfalcao]

I have watched this twice, still have no idea what your talking about