You are the best teacher period!! The passion with which you teach only with an intention to teach the subject but not for views is crystal clear in every video..Thank you so much sir for being real teacher in virtual platform
Thanks Sharma ji..Chalo finally mujhe wo comment padhne ko mila jiska wait main. Pichle 2.5 years se kar rha hu.Finally apko samjh aaya ki views pane ke liye hi videos bnaye jate hain aur UA-cam PE tricks dikhake students ko apne institutions me divert karne ki ya apna product sale karne ki koshish hi ki jati hai usse main alag karne ki soch ke saath is platform par aaya tha wo aaj yakeen me badlna start hua mujhe. Thanks for being part of Innozant family.Have a wonderful ahead..Keep learning ❤️.Keep Exploring ❤️👍
Really sir bhut ache se easily explain Kiya and ye find and replace wala hi topic bhut confusion ho rha tha but aapne ache se smjhaya thankyou sir...❤️❤️✨
Fantastic ! Bravo ! . I went through lot of videos and I found people teaching excel are half baked teachers, I mean half baked products. They really never get to the point. You are doing a wonderful job. Hats Off to you. You are brilliant. I appreciate your hard work and efforts you put in each videos. Your motivation keeps inspiring people. Keep up the good work. May Allah bless.
सर आप हमेशा बहुत जरूरतमंद वीडियो उपलब्ध कराते हैं। मै Text Function से आजकल नये नये question solve करा हूँ | आपके Text Function विडोज़ मुझे अच्छे से क्लियर हो चुके है |
the explanation you give is wonderful. thanks alot. but i have a Ques if a have space, point, Quma etc then how can i seperate irrespective of these condition.
@@Innozant sir mne apke contact no pr contact kiya tha course purchase k liye mujhe satisfied reply nhi mila or payment ka link dene ko bhi bola vo bhi nhi mila sir plz mra solution kro m apka course purchase krna chata hu
Hi Sir , want to know ki hum formulae me (--) kyun use krte hey , for an example SUMPRODUCT(--MID(C9,ROW(INDIRECT("1:"&LEN(C9))),1)) isme, MID ke pehele double dash kyu use kiya hey.. pls give an answer if any ne know.. ?
While Applying the Right formula you have selected LEN(A3) and you found total length was 11 so after the selection which key you press to see that "11" value ? Please help.
Sir good but i have aa some problem Apne ik space se bataya hai kaise find kare or right se output nikale but sir exp.. Navjit private limited company punjab 143301 Pahul govt company himachal 856321. Sir enke agge ham right ke state or code kise output nikale left right se ja other formule se Sir plc this problem solved Output Punjab 143301 Himachal856321
You may connect Live ,Will give you time slot then will discuss and explain your query and give you solution else add this question in upcoming MIS INTERVIEW cracker series .🙂👍
Sir Good morning Sir I received a list same students as Colum 1 Sr no Colum 2 Scholar No Colum 3 Student Name As Colum 2 Scholar no 20U01023 Heyer First two digit admission year next One digit courses next two digit branch next three digit Sr No or roll no 20U01023 = Admission Year 2020, UG, Electronics branch, 023 Roll nomber I set formulas Admission year 2020 and current month lass than December then I semester Fee 40000 Next current year 2021 and month December 20 to july 2021 then II sem and Fee 35000 Next year 2021 and month Aug to nov then III SEM FEE 25000 PLEASE HELP ME YEAR AND MONTH formulas
You are the best teacher period!! The passion with which you teach only with an intention to teach the subject but not for views is crystal clear in every video..Thank you so much sir for being real teacher in virtual platform
Thanks Sharma ji..Chalo finally mujhe wo comment padhne ko mila jiska wait main. Pichle 2.5 years se kar rha hu.Finally apko samjh aaya ki views pane ke liye hi videos bnaye jate hain aur UA-cam PE tricks dikhake students ko apne institutions me divert karne ki ya apna product sale karne ki koshish hi ki jati hai usse main alag karne ki soch ke saath is platform par aaya tha wo aaj yakeen me badlna start hua mujhe.
Thanks for being part of Innozant family.Have a wonderful ahead..Keep learning ❤️.Keep Exploring ❤️👍
Really sir bhut ache se easily explain Kiya and ye find and replace wala hi topic bhut confusion ho rha tha but aapne ache se smjhaya thankyou sir...❤️❤️✨
Really using replace function is very smart move i liked this really aapki videos always my favourite and your teaching style too❤❤❤
Thanks Jha Ji..Keep learning and Keep Growing 👍
It shows how much dedicated you are in the teaching field which is reflected through your self thought examples.
Wow!
Amazing Sir!! learning with fun.
zabar10!!! There are No words to appreciate your style of teaching.
Thanks Zahoor Sahab.🙏❤️
Sir you are a "SUPERB TEACHER" having best knowledge of excel..Salute
Thanks Gurpal Sahab❤️🙏
Fantastic ! Bravo ! . I went through lot of videos and I found people teaching excel are half baked teachers, I mean half baked products. They really never get to the point. You are doing a wonderful job. Hats Off to you. You are brilliant. I appreciate your hard work and efforts you put in each videos. Your motivation keeps inspiring people. Keep up the good work. May Allah bless.
Thanks Mushtaq Ahmed Sahab for your valuable appreciation.Really means a lot to me dear.
#aap kafi aasani se smjha dete h....sir.🙏
Thanks Vivek Ji👍
No words to explain sir ! Great teaching style
Thanks Mira for valuable appreciation dear..God bless You..Thanks for being part of Innozant Family ❤️👍
Sir you are the best teacher of excel 🙏
Thanks Pawan Ji❤️❤️
amazing as usual...!
*** You are the best ***
Great 👌💥💥💥💥 great 👌
Mja aagya srji aajto waooo
Wait for new video...on text..isse bhi behtar
You Are The Chemp I Salute You Guru G🙏
Thanks Rajesh Ji
U have explained very confusing thing in a easy way. very understandable!!
Thanku sooo much for making this excel very easy
Thanks Jaishri for such a.lovely feedback from you always,M trying my best to deliver good content.Happy learning
Great easy way explanation...Thanks and regard.
Thanks Asif.
❤️❤️
Superb!
Thank you , great help
you are very good teacher
सर आप हमेशा बहुत जरूरतमंद वीडियो उपलब्ध कराते हैं। मै Text Function से आजकल नये नये question solve करा हूँ | आपके Text Function विडोज़ मुझे अच्छे से क्लियर हो चुके है |
Great zabardast
Thank you so much, the concept is clear.
Thanks dear ❤️
Very nice 👌
❤️
the explanation you give is wonderful. thanks alot.
but i have a Ques if a have space, point, Quma etc then how can i seperate irrespective of these condition.
Such a nice video for learners like me
Thanks 👍
Just amazing sir,god bless u
Thanks Kunjal❤️
You are erudite of excel
What's is the short cut key 11-7 which is showing there
Mind blowing
👍Jata ji 🙏आपका video मुझे बहुत पसंद है मैं daily देखता हूँ..... Split function me limit kaise de skte hai ki itne letter ko split kare
Thanks Ritesh Ji..❤️
Sir 5:04 pe replace mein jab hum first name nikaalte hain toh any random number like 10, 20, ya 30 ko place kar sakete hain na formula mein all time?
Haan kar skte hain but single cell ke loye na ki group of data ke liye
Super sir ji
Thank u sir ji 😊
Sir vba ka pdf nahi daal rahe kya ?
Kaunsa pdf upload karna hai VBA ka?
Jab questions karayenge to uske sheet share kiye jayenge
@@Innozant sir jo theory bataye hai videos mein different questions hai jo
Sir how do you use the f9 function to evaluate the formula, I am using it but how to reverse back to the original
Well done
Thanks a lot sir
Thanks Neha .God bless You dear..Happy learning ❤️
good😀
Good formula
Thanks sir
Sir i have to extract from HO/21/EXPINV/1688
Sir ap fifo first in first out ka formula bta skte ho ho kya different item pr kse lga skte h plz
Sure dear...will make a video for the same.
@@Innozant sir mne apke contact no pr contact kiya tha course purchase k liye mujhe satisfied reply nhi mila or payment ka link dene ko bhi bola vo bhi nhi mila sir plz mra solution kro m apka course purchase krna chata hu
ap samjhayo to sab shikh jay ga ,, sir excel ka ek advance course ka playlist banayiga to help hota
Complete advance series hi hai playlist dear..kindly watch all
Excellent
Thanks Dear
Hi Sir , want to know ki hum formulae me (--) kyun use krte hey , for an example SUMPRODUCT(--MID(C9,ROW(INDIRECT("1:"&LEN(C9))),1)) isme, MID ke pehele double dash kyu use kiya hey.. pls give an answer if any ne know.. ?
While Applying the Right formula you have selected LEN(A3) and you found total length was 11 so after the selection which key you press to see that "11" value ? Please help.
🔥🔥🔥🔥🔥🔥🔥
❤️❤️❤️
Sir isme jo replace se first name nikala h usme length jyada aa rhi h please solve this problem.
Sr apki email id dena kuch puchna h apse ek question h interview me pucha tha ho ni rha
sir replace sy mid value kesy aye gi kindly yh b bta dn
Ok...next tips an tricks video me ya Interview Cracker series me add kar denge..😊
@@Innozant thnx g
Sr kya apne MID formula krwaya h kya
Agr yes to please link share krdo pls
Abhi nahi...upcoming video me aayenge ..Right aur mid and many more
sir -1 use karne se value error a raha ha ka karu ?
left function pe
Sir, it take middle name and last name both in case of middle name like Kumar Sahu from Ram Kumar Sahu.
Solution is there in another video.tips and tricks series
sir agr aise question hai
ankit
deepak kumar
mukesh kumar meena
alex adam rio jacob
isko kaise solve krenge
👍👍👍👍
❤️❤️❤️❤️❤️
Sr ek mid ka be bnaoo video
Virendra ji. ,Aapko bolne ki jarurat hi nhi..apko har wo video milenge jo aapne socha hoga ki kaas....
Please make the numbering in videos easy to find
Seprate playlist is there for every topic
❤👍🙂
bhut sari file hai usme se iss playlist ka konsi hai sir plzz name bta dijiye
Playlist wise file hain
@@Innozant yes sir thanku mil gya u r the best excel teacher
how to get back from evaluated formula after pressing f9
????
Undo..Ctrl z
@@Innozant Thanks a lot . best excel video series on UA-cam.
Wow
Replace wale method se length galat aa rhi h sir character jyada show kar raha h how can i solve this ? Please help 🙏
Problem solve ho gaya guru ji thanks for your amazing study 😊🥰
👍
How can I meet you ???
You may visit Innozant institute.For more information visit Innozant website
Sir workksheet ka name nhai dekh rha h. Fir download files me kse dudhe file ko😢.
Playlist wise hai assignement
Great Guruji but I need a help aap ne jawab nahi diya...
Kya query..bht saare aate hain query dear
.niche chala gya hoga
with use of replace function please extract middle name
Ok..Deepak..kisi video me add kr deta gu ye question dear
🙏
=Right(J49,LEN(J49)- SEARCH ("@", SUBSTITUTE(J49," ","@",2)))
Sir ye function kya hai isko difine kar dete samjh me nahi aa raha hai..
ye already video hai Dharmendra wk baar dekhke smjhne ki koshish kijiye nhi aaye smjh then let me knw
Flash fill to andhshradha he
500/600=600
600/500=600
Badi sankhaya search karna
Ek video is par bhi bana fo
🌟🌟🌟🌟🌟
Sir mujhe aapka number chahiye plz help us
@innozantofficial telegram id
Yadi ek se jyada space ho to
to bhi koi issue nhi h..requirement ke hiqab se function apply krenge ..jaise trim
Sir good but i have aa some problem
Apne ik space se bataya hai kaise find kare or right se output nikale but sir exp..
Navjit private limited company punjab 143301
Pahul govt company himachal 856321.
Sir enke agge ham right ke state or code kise output nikale left right se ja other formule se
Sir plc this problem solved
Output
Punjab 143301
Himachal856321
You may connect Live ,Will give you time slot then will discuss and explain your query and give you solution else add this question in upcoming MIS INTERVIEW cracker series .🙂👍
Last name using right samajh nahi aaya
Len nikal lein aur usme se - find jahan slace hai..ek baar alt t u f press krke debig krke dekhiye .aayega samah..dubara dekhiye video
Sir Good morning
Sir I received a list same students as
Colum 1 Sr no
Colum 2 Scholar No
Colum 3 Student Name
As Colum 2 Scholar no 20U01023
Heyer First two digit admission year next One digit courses next two digit branch next three digit Sr No or roll no
20U01023 = Admission Year 2020, UG, Electronics branch, 023 Roll nomber
I set formulas Admission year 2020 and current month lass than December then I semester Fee 40000
Next current year 2021 and month December 20 to july 2021 then II sem and Fee 35000 Next year 2021 and month Aug to nov then III SEM FEE 25000
PLEASE HELP ME YEAR AND MONTH formulas
This is too much difficult. I always prefer Text to Columns rules.
Joydeep..Text to column is fine but what if we chage the source data😀?
Suppose someone’s name is Amrit Kumar Sharma.. now put this name with other name and title and extract first last names
Thanks sir