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.com/drive/folder...
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantofficial
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#findandsearch #searchfunction #findfunction #excelfindandsearch
Пікірлер: 163
Boss, you are a real and good teacher in excel in my eyes bcz your teaching technique is very smart. Carry on Boss
@Innozant
3 жыл бұрын
Thanks Saidur Rahman Sahab for your valuable appreciation..Happy learning ❤️❤️
Thank you so much sir! This gave a clear picture of the functions!!!
@ramkishoryadav9087
12 күн бұрын
kzread.info/dash/bejne/Z45hqsqqoqXQk7w.htmlsi=jxgXIyA6GoL3eAyY
Apke video dekhne mza hi kuch alag ata hai
@Innozant
11 ай бұрын
Thanks dear .Keep Learning
Thank you for the video, finally i am able to understand the difference.
@Innozant
Жыл бұрын
Thanks Himani. keep learning ❤️
thank you sir for this informative video 🙏
@Innozant
3 жыл бұрын
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...👍
Thanks Sir, well explained.
@Innozant
2 жыл бұрын
Thanks Tarun♥️
Thank you sir for this video ,my doubt is clear , waiting for next Video.😊
@Innozant
4 жыл бұрын
Thanks Ashu..Soon dear
SUPER Sir .... Concept is very clear now. Thank you ...👌👍
@ramkishoryadav9087
12 күн бұрын
kzread.info/dash/bejne/Z45hqsqqoqXQk7w.htmlsi=jxgXIyA6GoL3eAyY
Aap ek achhe sikshak h , hme bahut kuchh aapse sikhne ko mila h
@Innozant
Жыл бұрын
Thanks
Best Teacher Ever.. Thank you Sir
@ramkishoryadav9087
12 күн бұрын
kzread.info/dash/bejne/Z45hqsqqoqXQk7w.htmlsi=jxgXIyA6GoL3eAyY
Sir app boht acha explain krta ho
Sir aap bahut achha sikhate Hain
Thank you ☺️💖
@Innozant
3 жыл бұрын
Thanks dear..Happy learning
Excellent
Very nice discrimination. Keep it Dear.
@Innozant
2 жыл бұрын
👍❤️
The best teacher on excel formulas or functions. Keep it up sir. Respect from Pakistan.
@Innozant
3 жыл бұрын
Thanks dear ❤ for your lovely appreciation..Happy learning..God bless you dear.
@ramkishoryadav9087
12 күн бұрын
kzread.info/dash/bejne/Z45hqsqqoqXQk7w.htmlsi=jxgXIyA6GoL3eAyY
Super Brother, App ka samjany ka tarika bht acha hai👍
@Innozant
Жыл бұрын
Thanks Adil.Keeo Learning
Well explained sir ...thank you so much
@ramkishoryadav9087
12 күн бұрын
kzread.info/dash/bejne/Z45hqsqqoqXQk7w.htmlsi=jxgXIyA6GoL3eAyY
गुरुजी आप बहुत अच्छे शिक्षक हो सभी पुरानी सीरीज के वीडियो देख रहा हु बहुत कुछ सिखने को मिल रहा है 🙏🙏🙏
@Innozant
2 жыл бұрын
Thanks Manish Ji aapke valuable comment ke liye ..God bless You ❤️
Here we can use text to column and separate by space .
Sir ap bhut acha sumjhte ho
@Innozant
Жыл бұрын
Thanks Rizwan
सर आपने Find and Search Functions बहुत ही अच्छे सै समझाया | आप बहुत अच्छा शिखाते हो |
@Innozant
4 жыл бұрын
जल्द आपको वीडियो देखने को मिलेगा एडवांस्ड लेवल find and Search.
Thanku sir 🙏
Thank you so much sir you are awesome ❤
@ramkishoryadav9087
12 күн бұрын
kzread.info/dash/bejne/Z45hqsqqoqXQk7w.htmlsi=jxgXIyA6GoL3eAyY
TQ....SIR...🙏🙏
tq sir
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
2 жыл бұрын
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
2 жыл бұрын
@@Innozant hmm sure sir!!😊
Good one Bro!!
@Innozant
2 жыл бұрын
❤️❤️
This is mind blowing...
@ramkishoryadav9087
12 күн бұрын
kzread.info/dash/bejne/Z45hqsqqoqXQk7w.htmlsi=jxgXIyA6GoL3eAyY
Bro, you are very very good
@ramkishoryadav9087
12 күн бұрын
kzread.info/dash/bejne/Z45hqsqqoqXQk7w.htmlsi=jxgXIyA6GoL3eAyY
Again an excellent video...
@Innozant
2 жыл бұрын
Thanks Payal.. Happy learning dear❤️❤️
@payaljain5497
2 жыл бұрын
@@Innozant Sir please tell me what is a text string in excel in simple language?
Interesting😊
Thnq sir
#you are great sir🙏
@Innozant
Жыл бұрын
Thanks Vivek
Helpfull video..
@Innozant
2 жыл бұрын
Thanks
Super se upar
Interesting🤓
Great Way to teaching sir :)
@ramkishoryadav9087
12 күн бұрын
kzread.info/dash/bejne/Z45hqsqqoqXQk7w.htmlsi=jxgXIyA6GoL3eAyY
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
8 ай бұрын
Seprate playlist are there,You mayblearn things playlist wise in sequence
Thanks sir
@Innozant
4 жыл бұрын
Thanks Bhoopendra ,Acha lagta hai aap harek video dekhte hain aur usse seekhte hain
Your voice is like a @abhishar sharma news anchor
Sir mza aa gya video me
@Innozant
Жыл бұрын
Thanks Shivam Ji
wao very super oncept sir ji kiya baat hai aaap ki
@Innozant
3 жыл бұрын
Thanks dear..❤❤
BAHUT SUNDAR SIR JI !!!
@ramkishoryadav9087
12 күн бұрын
kzread.info/dash/bejne/Z45hqsqqoqXQk7w.htmlsi=jxgXIyA6GoL3eAyY
Subscribed :)
@Innozant
2 жыл бұрын
👍♥️
You are good teacher in excel
@ramkishoryadav9087
12 күн бұрын
kzread.info/dash/bejne/Z45hqsqqoqXQk7w.htmlsi=jxgXIyA6GoL3eAyY
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
3 жыл бұрын
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
12 күн бұрын
kzread.info/dash/bejne/Z45hqsqqoqXQk7w.htmlsi=jxgXIyA6GoL3eAyY
Thanks for the helpful video Sir.
@Innozant
3 жыл бұрын
Thanks Dear...
@princemjprasanth8954
3 жыл бұрын
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
3 жыл бұрын
Please Sir, it is very urgent. Thank you.
@Innozant
3 жыл бұрын
Core Excel ,vlookup series aur pivot table kriye complete pehle
@princemjprasanth8954
3 жыл бұрын
@@Innozant thank you so much Sir.
nice sir 👍🏻👍🏻👍🏻👍🏻
@Innozant
3 жыл бұрын
thanks
woow sir
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
Great
@Innozant
4 жыл бұрын
Thanks Rana Ji,Hope you may learn from this and enhance your skills
Hello sir... am waiting your next video......😍😍😘
@Innozant
4 жыл бұрын
Bht jald Jitendra ji..
👏👏👏 osm sir
@Innozant
2 жыл бұрын
Thanks Jay❤️
GOOD
Good
❤️
🙏
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…
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
2 жыл бұрын
Kindly watch excel maharaj series
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
Sir ji minus one ka concept kya hai
Maza Aa Gaya! 😅😅😅
@Innozant
3 жыл бұрын
Thanks Pawan Ji..❤️🙏😁👍
Sir ap ms office 2013 use krte ho?
@Innozant
3 жыл бұрын
Haan pehle krte the abhi to office 2019 aur office 365 krte h use
Sir ek video banaiye excel cell calulation pe please
@Innozant
3 жыл бұрын
Already hain video .Basic excel playlist me dekhiye.
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
3 жыл бұрын
kindly explain tge criteria..what output you want
@muhammadshahid5153
3 жыл бұрын
@@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.
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
3 жыл бұрын
Please find this video in Excel Maharaj playlist..Excel text maharaj
Salam sir Plz teach us container movement sheets format for nvocc shipping company
@Innozant
3 жыл бұрын
Oo..will plan to make seprate vidoe for the same
Sir - (I am An Indian ) how we can find small a and how many count
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
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
Sr isme right ka nikalna hoto
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
2 жыл бұрын
Better hoga excel sheet share kriye with query explanation
@shivkumarshakya2280
2 жыл бұрын
@@Innozant ok sir
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.
शब्द नही है सर कैसे धन्यवाद करू आपका।
@Innozant
3 жыл бұрын
Thanks Nath..aaapke ye word bht mayne rakhta h mere liye❤🙏
Sir aap ka excel sheet download me bhaut options aate he bha sheet nahi mile rahi he please help me
Sir iski next video kaha hy continuation?
@Innozant
Жыл бұрын
Usi playlist me sequence me hoga
Sir abhi abhi aapne jo Facebook pe video upload kiya hai उससे mere friends me बहुत खलबली मच गयी है. They are positively uncomfortable now. Thanks
@Innozant
2 жыл бұрын
Hahaha...Aisa kya...?kya impact aaya unke mindset mr❤️?
@shrikantbadge3978
2 жыл бұрын
@@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.
RIGHT(A14,FIND(" ",A14)-5) Right ka btao sr kse hoga
@Innozant
4 жыл бұрын
Right aise nhi use karte hain length ke saath hoga use..bahot jald apko video dekhne ko milega..bht detail mein
Very nice, sir सब से अलग लेकचर, यदि पूरे पेज में स्पेस ढूढ़ ना हो तो क्या करें।
@Innozant
3 жыл бұрын
❤🙏🙏
Second part ???
@Innozant
3 жыл бұрын
already there
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 🙏🙏
Sir 200/400=400 5000/3000=5000 कहने का मतलब बड़ी संख्या को लाना
Sir ye wala samj ni aa raha hai please help Search ("functions*2013, within text) Ans 7 ?? Kaise Pls help sir
@Innozant
2 жыл бұрын
Dear ye btaya hai ki wildcard use kar sakte hain search function me..
@paramjeet975singh3
2 жыл бұрын
@@Innozant ok sir thanx
Bahut options aarhe he me aap ki abhi jo video dekhu bahi seet ho only Kay se find Karu
@Innozant
3 жыл бұрын
Ok seprate link daal dunga main file ka..waise text Function folder me hi Hoga assignment dear
Sir, teach a little slowly.
@Innozant
Жыл бұрын
Sure
Sir aap kaha we go Kya aap apna number de sakte ho
Excellent
@Innozant
2 жыл бұрын
Thanks dear ❤️