Find and Search Functions |Difference between find and Search in Excel

Find and Search Functions |Difference between find and Replace in Excel
1. Both functions find the position of a substring in a string the position of some characters within a different set of characters.
2.FIND is case sensitive and does not allow wildcards
3.SEARCH is NOT case sensitive and it accepts wildcards.
4.Use LEFT FIND and SEARCH to extract first names
Download the Assignment Master Practice Folder here (All Example at one place)
drive.google.c...
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantofficial
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#findandsearch #searchfunction #findfunction #excelfindandsearch

[@saidurrahman3754]

Boss, you are a real and good teacher in excel in my eyes bcz your teaching technique is very smart. Carry on Boss

[@Innozant]

Thanks Saidur Rahman Sahab for your valuable appreciation..Happy learning ❤️❤️

[@seedhibaat7741]

The best teacher on excel formulas or functions. Keep it up sir. Respect from Pakistan.

[@Innozant]

Thanks dear ❤ for your lovely appreciation..Happy learning..God bless you dear.

[@ramkishoryadav9087]

czcams.com/video/5Z-HhqrBjcY/video.htmlsi=jxgXIyA6GoL3eAyY

[@nishachauhan9103]

Mujhe excel related vedio jab dekhni hoti hai mai sabse pehle youtube par aapke vedio hee search krti hu , aur jab aapki vedio se satisfied nhi hoti to kahi aur jaati par abi tak esa hua hee nhi , ,, aapke vedio se mai poori tarah satisfied ho jaati hu aur kahi doosri jagah search nhi krti hu , thanku dil se , mera time waste hone se bachane ke liye 🤗🤗🤗🤗🤗🤗🤗🤗🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌🙌

[@Innozant]

Nisha aapke ye comment mere liye sachme bht mayne rakhta hai..God bless you..Hope apke life me ye videos value add kar rahe hain..

[@ramkishoryadav9087]

czcams.com/video/5Z-HhqrBjcY/video.htmlsi=jxgXIyA6GoL3eAyY

[@MrBadariNarayan]

SUPER Sir .... Concept is very clear now. Thank you ...👌👍

[@ramkishoryadav9087]

czcams.com/video/5Z-HhqrBjcY/video.htmlsi=jxgXIyA6GoL3eAyY

[@nairchandnichandran7503]

Thank you so much sir! This gave a clear picture of the functions!!!

[@ramkishoryadav9087]

czcams.com/video/5Z-HhqrBjcY/video.htmlsi=jxgXIyA6GoL3eAyY

[@soumyadityasen121]

Best Teacher Ever.. Thank you Sir

[@ramkishoryadav9087]

czcams.com/video/5Z-HhqrBjcY/video.htmlsi=jxgXIyA6GoL3eAyY

[@shreyakanojia3242]

Oh my goodness!!! Finally I got the Video jismai difference samjh mai aya😑💯...I got so puzzled in these two terms but now all clear thank u sir!!👍😊

[@Innozant]

Thanks Shreya,,Basic excel playlist se sequence me step by steo seekhna hai aapko.. already Complete master assignment folder hai wo download kar leij aur practice regular basis par karen

[@shreyakanojia3242]

@@Innozant hmm sure sir!!😊

[@ashupuniya1504]

Thank you sir for this video ,my doubt is clear , waiting for next Video.😊

[@Innozant]

Thanks Ashu..Soon dear

[@himanifartiyal5407]

Thank you for the video, finally i am able to understand the difference.

[@Innozant]

Thanks Himani.
keep learning ❤️

[@uniformfactory277]

Super Brother, App ka samjany ka tarika bht acha hai👍

[@Innozant]

Thanks Adil.Keeo Learning

[@Poddarjii2011]

Aap ek achhe sikshak h , hme bahut kuchh aapse sikhne ko mila h

[@Innozant]

Thanks

[@sunilkumarprajapati9246]

Sir your video are very valuable and very advanced. Things are very clear. Sir I have a request to you can you combine all your videos to a mega video. So that any one can see all your videos in one mega. That will help very much who wanted to know excel very well. Your are a great person and helping lot to the people. Seriously think about and give as mega video so that I have not to search every time.

[@Innozant]

Seprate playlist are there,You mayblearn things playlist wise in sequence

[@AmanbaghelicomedyRewa]

Sir aap bahut achha sikhate Hain

[@Learn_withkd]

Too good 👍👍👍

[@AftabAhmed-uw4ki]

Sir app boht acha explain krta ho

[@ManishVerma-gg8xl]

गुरुजी आप बहुत अच्छे शिक्षक हो सभी पुरानी सीरीज के वीडियो देख रहा हु बहुत कुछ सिखने को मिल रहा है 🙏🙏🙏

[@Innozant]

Thanks Manish Ji aapke valuable comment ke liye ..God bless You ❤️

[@jaynandangiri4401]

Apke video dekhne mza hi kuch alag ata hai

[@Innozant]

Thanks dear .Keep Learning

[@alexasaifi6459]

Thank you so much sir you are awesome ❤

[@ramkishoryadav9087]

czcams.com/video/5Z-HhqrBjcY/video.htmlsi=jxgXIyA6GoL3eAyY

[@sandeepaswal8944]

सर आपने Find and Search Functions बहुत ही अच्छे सै समझाया | आप बहुत अच्छा शिखाते हो |

[@Innozant]

जल्द आपको वीडियो देखने को मिलेगा एडवांस्ड लेवल find and Search.

[@divyanshshri6291]

tq sir

[@pspclmaur2631]

Very nice discrimination. Keep it Dear.

[@Innozant]

👍❤️

[@Rizwan_ansari_0726]

Sir ap bhut acha sumjhte ho

[@Innozant]

Thanks Rizwan

[@sumanbhandari558]

BAHUT SUNDAR SIR JI !!!

[@ramkishoryadav9087]

czcams.com/video/5Z-HhqrBjcY/video.htmlsi=jxgXIyA6GoL3eAyY

[@Investophillia]

#you are great sir🙏

[@Innozant]

Thanks Vivek

[@harshit4532]

Thanku sir 🙏

[@rahulrakshe1988]

You are good teacher in excel

[@ramkishoryadav9087]

czcams.com/video/5Z-HhqrBjcY/video.htmlsi=jxgXIyA6GoL3eAyY

[@user-ut6eq3ex2r]

Interesting😊

[@sadashivkage3133]

TQ....SIR...🙏🙏

[@FromAllThe_Angles]

you are a clever teacher. I do not understand indian language but I watched the whole video and I got the idea that I need. can you please make videos speaking in english?

[@Innozant]

Thanks dear will try to add English subtitles

[@tarunsehgal5789]

Thanks Sir, well explained.

[@Innozant]

Thanks Tarun♥️

[@slimuddinnurnabi254]

Bro, you are very very good

[@ramkishoryadav9087]

czcams.com/video/5Z-HhqrBjcY/video.htmlsi=jxgXIyA6GoL3eAyY

[@abhishekguleria1800]

Great Way to teaching sir :)

[@ramkishoryadav9087]

czcams.com/video/5Z-HhqrBjcY/video.htmlsi=jxgXIyA6GoL3eAyY

[@prosanjitbhura1901]

This is mind blowing...

[@ramkishoryadav9087]

czcams.com/video/5Z-HhqrBjcY/video.htmlsi=jxgXIyA6GoL3eAyY

[@AlimKhan-bl5sh]

Sir text string me jo tiisre nmbr ka o hai uske position to nahii nikal rahi... Ek to innozant me o hai or 2 technologyies me hai.. Isme jo tisra o hai uski position ku nahii nikal rahii hai

[@user-ut6eq3ex2r]

Interesting🤓

[@VimalKumar-ih6ik]

Super se upar

[@payaljain5497]

Again an excellent video...

[@Innozant]

Thanks Payal.. Happy learning dear❤️❤️

[@payaljain5497]

@@Innozant Sir please tell me what is a text string in excel in simple language?

[@shivamchaurasiya2450]

Sir mza aa gya video me

[@Innozant]

Thanks Shivam Ji

[@muhammadzeeshan-ee8sv]

Excellent

[@learnshortexcel7685]

Well explained sir ...thank you so much

[@ramkishoryadav9087]

czcams.com/video/5Z-HhqrBjcY/video.htmlsi=jxgXIyA6GoL3eAyY

[@sayamkhan2492]

Your voice is like a @abhishar sharma news anchor

[@sawaimalhi8439]

wao very super oncept sir ji kiya baat hai aaap ki

[@Innozant]

Thanks dear..❤❤

[@BetterLifePhilosophies]

Good one Bro!!

[@Innozant]

❤️❤️

[@shaktisinhgohil6599]

Thank you ☺️💖

[@Innozant]

Thanks dear..Happy learning

[@user-zg9bv4ky9v]

Sir jab name mein space hota hai to mil jata hai first name. lekin jb single name only "deep" hai list mai or space ya koi dilimiter bhi nahi hai to value error ata hai please suggest me what to do.

[@princemjprasanth8954]

Thanks for the helpful video Sir.

[@Innozant]

Thanks Dear...

[@princemjprasanth8954]

Sir Excel to Maha samundar h, koyibhi company me kam karnekeliye, minimum kya janna h excel me. Ek list wise type karke bejiye sir. Pehle hum apka vahi video dekhna start karunga.

[@princemjprasanth8954]

Please Sir, it is very urgent. Thank you.

[@Innozant]

Core Excel ,vlookup series aur pivot table kriye complete pehle

[@princemjprasanth8954]

@@Innozant thank you so much Sir.

[@Jitenderkumar-yp1rn]

Hello sir... am waiting your next video......😍😍😘

[@Innozant]

Bht jald Jitendra ji..

[@GauRavSinghTomer]

Here we can use text to column and separate by space .

[@BetterLifePhilosophies]

Subscribed :)

[@Innozant]

👍♥️

[@dhakafady774]

woow sir

[@gardhariyajayesh7670]

Helpfull video..

[@Innozant]

Thanks

[@jaymakwana7490]

👏👏👏 osm sir

[@Innozant]

Thanks Jay❤️

[@vishaltanwar8318]

Sir I need your help
Sir example jo MIS main pucha tha
Apple
Amar
Anju
Viahal
Muje esme nikalna hai kitne name A se start ho rahe hai

[@RA-rh5lb]

Sir ji minus one ka concept kya hai

[@vivekmusafir4492]

Hey thnx. For the tutorial…however I have a bit complex scenario…I want to identify cells with similar text ..Example: suppose there are 100 rows with company name…in few it’s mentioned as “ABC PVT. LTD.” and in some it’s mentioned as “ABC PVT. LTD” here in second scenario there is no dot at the end of string LTD…in reality these companies are same but excel will treat them two different companies…I want to identify such companies so that name correction could be done…please help me out…it’ll save tons of time for me…

[@abdullavazhayil4868]

Here the demo with three words ...how it will be more than three words and more separators like spaces or dashes... please do a video?

[@Innozant]

Kindly watch excel maharaj series

[@gauravbhatia7987]

Thnq sir

[@bhoopendraraghav9781]

Thanks sir

[@Innozant]

Thanks Bhoopendra ,Acha lagta hai aap harek video dekhte hain aur usse seekhte hain

[@PrateekGoyal013]

GOOD

[@manojprakash1044]

Sir ap ms office 2013 use krte ho?

[@Innozant]

Haan pehle krte the abhi to office 2019 aur office 365 krte h use

[@vijaysahal4556]

nice sir 👍🏻👍🏻👍🏻👍🏻

[@Innozant]

thanks

[@Maayu_Vijay]

Sir aap ka excel sheet download me bhaut options aate he bha sheet nahi mile rahi he please help me

[@nivrittisarode7411]

Good

[@savitabirje4953]

Sir good afternoon
I have a big Message and this message against I wanna email ID, name, remove words, assign word and company name
Sir please tell me
Konsa formula se me ye sab nikal sakti hu sir

[@pawanverma7220]

Maza Aa Gaya! 😅😅😅

[@Innozant]

Thanks Pawan Ji..❤️🙏😁👍

[@user-vh2ct6ll7g]

Sir - (I am An Indian ) how we can find small a and how many count

[@kailashsaini1365]

Dear Sir if there are 4 spaces in any sentace, we want to find position of 4 th space in sentace. How ? plz reply

[@Innozant]

Please find this video in Excel Maharaj playlist..Excel text maharaj

[@rajesh_pote]

❤️

[@pranjalkastwar8731]

Sir video m apne search function wild card NHI SAMJHAYA ACHE SE

[@muhammadshahid5153]

Dear sir , I need your help.
Can we use search function with array when we need to search multiple items based on if condition.
Plz help.

[@Innozant]

kindly explain tge criteria..what output you want

[@muhammadshahid5153]

@@Innozant if call a5 contains cucumber so pick veg , if orance so fruits , if chicken so meat if pepci or sprite or seven up so cold drink. Cell a5 contains a long sentence in which there may be either of these words.
Is it possible to use array function with search to make the formula smaller and easier.
Need your help.
Regards.

[@RahulRoy-po9ct]

🙏

[@shivkumarshakya2280]

Dear Sir,
I want to apply formula Search with array
Required search value from One cell and search multiple value me se koi bhi match kare

[@Innozant]

Better hoga excel sheet share kriye with query explanation

[@shivkumarshakya2280]

@@Innozant ok sir

[@jaspalrana9541]

Great

[@Innozant]

Thanks Rana Ji,Hope you may learn from this and enhance your skills

[@virendersroha1754]

Sr isme right ka nikalna hoto

[@RajeshKumar-dk4mt]

Sir ek video banaiye excel cell calulation pe please

[@Innozant]

Already hain video .Basic excel playlist me dekhiye.

[@syedaqeelahmed7642]

Salam sir
Plz teach us container movement sheets format for nvocc shipping company

[@Innozant]

Oo..will plan to make seprate vidoe for the same

[@shivkumarshakya2280]

Like
A1 Cell Value with text
ABC XYZ JBQ IBC
and search any one multiple value
1 ABC
2 MNQ
3 YBC
4 IBC
sir ye multiple value a1 cell me rakha text me se koi bhi find karni hai
Please suggest me formula it's Very Very Urgent Sir 🙏🙏

[@shrikantbadge3978]

Sir abhi abhi aapne jo Facebook pe video upload kiya hai उससे mere friends me बहुत खलबली मच गयी है. They are positively uncomfortable now. Thanks

[@Innozant]

Hahaha...Aisa kya...?kya impact aaya unke mindset mr❤️?

[@shrikantbadge3978]

@@Innozant pata nahi, I used to tell them same thing but did not listen but you as a professional said this that's why they took it seriously.

[@AzharKhan-kd9bf]

Sir iski next video kaha hy continuation?

[@Innozant]

Usi playlist me sequence me hoga

[@paramjeet975singh3]

Sir ye wala samj ni aa raha hai please help
Search ("functions*2013, within text)
Ans 7 ??
Kaise
Pls help sir

[@Innozant]

Dear ye btaya hai ki wildcard use kar sakte hain search function me..

[@paramjeet975singh3]

@@Innozant ok sir thanx

[@nathalstone9269]

शब्द नही है सर कैसे धन्यवाद करू आपका।

[@Innozant]

Thanks Nath..aaapke ye word bht mayne rakhta h mere liye❤🙏

[@BalvirSingh-qs9kz]

Very nice, sir सब से अलग लेकचर, यदि पूरे पेज में स्पेस ढूढ़ ना हो तो क्या करें।

[@Innozant]

❤🙏🙏

[@muzaffarali3399]

Sir 200/400=400 5000/3000=5000 कहने का मतलब बड़ी संख्या को लाना

[@virendersroha1754]

RIGHT(A14,FIND(" ",A14)-5)
Right ka btao sr kse hoga

[@Innozant]

Right aise nhi use karte hain length ke saath hoga use..bahot jald apko video dekhne ko milega..bht detail mein

[@Maayu_Vijay]

Bahut options aarhe he me aap ki abhi jo video dekhu bahi seet ho only Kay se find Karu

[@Innozant]

Ok seprate link daal dunga main file ka..waise text Function folder me hi Hoga assignment dear

[@Thecinemaescape1994]

Second part ???

[@Innozant]

already there

[@harshit4532]

Sir, teach a little slowly.

[@Innozant]

Sure

[@SunilKumar-ed9cl]

Sir aap kaha we go
Kya aap apna number de sakte ho

[@ishutiwari5567]

thank you sir for this informative video 🙏

[@Innozant]

Thanks Ishu🙏♥️ Welcome to Innozant Family.We welcome you to experience the taste of success with Innozant-Seed of Success.
If you are a beginner learner then recommend you to start learning from Playlist Basic Excel 1st video onwards.After completion of Basic Excel series proceed with Sorting & Filter,What if Analysis, Array & Sumproduct,Lookup Functions,Pivot Table and Daahboard etc. Happy Learning dear...👍

[@azhadshamim3122]

Excellent

[@Innozant]

Thanks dear ❤️