FIND() vs SEARCH() Function in Excel

[@jimcrain412]

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" ....

[@DaddyBear3000]

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.

[@nairobi203]

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

[@TeachExcel]

MY FULL EXCEL VBA COURSE (Beginner to Expert) [35% Discount]: www.teachexcel.com/vba-course-update.php?src=yt_pinned_comment_tep4wSgygVE
200+ Video Tutorials - 200+ Downloadable Excel Reference Files - 50+ Hours of Content

[@ekramhossain7014]

Thank u so much sir

[@nareshkumarmaurya5400]

Thanks sir

[@IvanCortinas_ES]

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

[@verdis1952]

Very helpful, thanks

[@moriravirajsinh1300]

Well explained...

[@wayneedmondson1065]

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

[@TeachExcel]

Thanks! I couldn't agree more! Honestly, if you don't use both of them for a few weeks, I find it too easy to forget which is which.

[@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.

[@keithfalcao1844]

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

[@jacobchama6562]

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

[@darrylmorgan]

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

[@TeachExcel]

Thanks! I'm glad you liked it! I'm thinking of maybe doing more in this style of comparing functions.

[@nadermounir8228]

Well explained thank you for your hard work

[@TeachExcel]

You're welcome! I'm glad you liked it! I'm thinking I might do more like this one.

[@lisaramaha2304]

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

[@sureshlovevanshi6944]

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

[@TeachExcel]

I'm not sure, I'd check out this link stackoverflow.com/questions/14667035/vba-for-excel-afterrefresh-event and if that doesn't help, ask on our forum on TeachExcel.com and provide as much info. as you can or a sample file.

[@Richkotite1]

Really well explained. Thank you.

[@TeachExcel]

You are very welome! I'm glad you think so :)