everytime I learn something in class and revise the entire course it seems easy😂😂😂 but when I open this channel...it seems there is a lot and its a vast course🙏🙏...so basically I m learning the basic while paying and learning the actual thing here witjout paying a single penny....you are doing a great job sir...❤️❤️❤️
Sir, jitna mai apke videos dekhta hu shayad hi koi dekhta hoga, jab bhi free hota hu dekh leta hu.. aur maine ek application bhi bna liya with the help of advanced excel. Aur pura sukh kar hi chodunga...thank you.
Thanks Mira aapke itne pyare aur valuable feedback ke liye mBht mayne rakhta hai merr liye ye words..Main koshish karunga ap sabhi ke life me kuch value yadi add kar sakun wahi hai mere liye success hona.❤️❤️❤️ Thanks for being part of Innozant Family
@@Innozant you told me I'll tell if something comes up for MIS executive post... When I told you I know advanced excel, SQL, Tableau but couldn't find job...as I'm fresher for 2 years... My mail ID is anurag14pro@gmail.com
thank to you for your support so that we can learn more about excel. one question which trouble, how find duplicate and solve like this data - contact no . 100 rows in a sheet, one, two ,three mobile no in sequent may be repeat one mobile no in three time
Abi b confused hoon m dourbra try karunga kiyn k use tu kr laita hoon aaap k le lecture ko par meri life m ye use nhe hota hai ..Bar bar bhool jata hoon ...Phir muje dil say ye he fell hota hai abi tak kuch nhe sekha bar bar nirasha ah jate hai q sir
Sir when i use search formula 3 time for 3 space its showing me only 2 time space value, if possible can you please response for understanding (Bagels, Muffins, and Breakfast) this is the format!
Sir, Great explanation... please guide if there is mixture of words like a table contains First and Last name, First Middle and Last name or First Middle1 Middle2 and Last name...how to extract last name from such table
@@Innozant Yes! i have large data having some extra multiple lines & i want to delete all of these extra lines, because i am facing much trouble to handle it.
SIR when we are doing copying its very east but when we are trying on our own it difficult , Practise practise and practise,,,, he continuous practise se aa jayena na i am preparing for MIS ,in our organisation opening are coming continous . want to crack this time anyhow
Dear Sir, suppose my name Anish Kumar Yadav , to find yadav =right(old txt,find(" ",oldtext)+1) here also bring me the last name, i am a learner, still now i learn every thing from you , is this formula right
sir kisi ka sir name "anshu ram" use condition m y formula m error aa rha, Y only us condition m le rha jab kisi ka last name "ansu aman sood" ho tab y last wala le rha h. mujhe aisa chaiye ki agar kisi ka name eg. rahul kumar, ya rahul kumar roy us condition m mujhe last name chaye bas
Hi sir pl suggest if We have date Like this so how can find the output. Data The cost USD Is 100 His Score is 79 Item core is 14258 Ticket number is 1245 We just want Numeric part and Text part both should be individual row and columns.
Sir ,jab output basically Lana hai minus plus karke hin, toh fir Left Right Mid in teeno ka kya sense hai mujhe nahi samajh aa raha hai!! Sorry sir aapke itna acchhe se mehnat se samjhane ke baad bhi mujhe fir se aapse puchna pad raha hai !!
@@Innozant sir mera kehne ka matlab hai ki ek certain length mei se ek certain length ko subtract hi toh hum kar rahe hain aur jo bach gaya wo humara output hai , fir isme Mid kya role play kar raha hai !koshish karta hun fir se samajhne ki thanks!!
Sir I have a doubt. मेरे पास एक लिस्ट है. Names की. जिसमें से मुझे first and last name अलग करने है. Left and find formula लगाने के बाद मेरा first name to अलग हुआ. Magar जहाँ - 2 list में only ek hi name है. वहाँ error show हो रही है. तो मुझे फिर अब कौन सा formula lagana hoga. Kindly send me syntax of formula.
Sir please isko explain ki ji ye...isko kaise kare...Pahle item details then item code Example 39258 calc = 0001 39258 calc red = 0002 Lekin order aaya hai 39258 red 120 chk calc 39258 regular calc In this case how to find the exact item code In order details
8 se 10 barr video ko dekha tab jaake samjh aya hai mere k find ko nested ku kar rahe the aap... Apne asal me kara kya hai.. Jo start number hai na uski jagah pe apne ek or find chala diya +1 add karke jisse k wo doosre space par pahuch gaya..ab jaake samjh aya hai😂😂
I have a query regarding replace formula that is- I use replace formula as below: 1000-33 replaced with 1000-033 1000-1 replaced with 1000-01 But want 1000-1 replaced with 1000-001 So I want to know how to use one replace formula or another adding formula which make the series of the Numbers
Sir you are the best 👍💯 teacher ever i met on youTube
It was really really a fantastic explanation and your effort is ultimate.....
Thanks Sujan..Happy learning ❤️🙏
everytime I learn something in class and revise the entire course it seems easy😂😂😂 but when I open this channel...it seems there is a lot and its a vast course🙏🙏...so basically I m learning the basic while paying and learning the actual thing here witjout paying a single penny....you are doing a great job sir...❤️❤️❤️
Thanks Suraj for such a valuable and amazing feedback from yours.Really means a lot to me🙏❤️
sir baar baar dhaikny k baad aj smajh aya k agla space per kaisy pohnchy nested if k through. thanks sir
Sir आप Concept बहुत अच्छे से क्लियर करवाते हो | Keep teaching we will keep learning . Appreciated for your precious effort, God bless.
Thanks Sandeep Ji,Keep learning dear
Wao sir, this is very automatically findings tricks, thank u so much sir ❤️💓🥳🎉👌👍🙏👏👏👏👏
Really you are a best teacher on TH-cam
Thanks ..Really means a lot to me
very nice sir ... i learned lot of formulas from you
Me to fill flash ctrl+e se karta tha , abhi kuch naya shikha isko try karunga , best teacher🎉
👍
Sir apne tough function ko asaan bana diya👍
Great explanation sir, u are such a genius ❣️
Thanks Jha Ji .Keep Learning ❤️
Bahut hi acha way hai samzane ka, jitni tareef karoo Kim hai
Thanks Jaishri
Thanks Jaishri,❤️
Sir, jitna mai apke videos dekhta hu shayad hi koi dekhta hoga, jab bhi free hota hu dekh leta hu.. aur maine ek application bhi bna liya with the help of advanced excel. Aur pura sukh kar hi chodunga...thank you.
Great...keep learning
Sir Kya clarity hai apki teaching style mein!
Thanks Mira aapke itne pyare aur valuable feedback ke liye mBht mayne rakhta hai merr liye ye words..Main koshish karunga ap sabhi ke life me kuch value yadi add kar sakun wahi hai mere liye success hona.❤️❤️❤️ Thanks for being part of Innozant Family
My excel best teacher❤❤❤❤
You are really a good teacher. 🙏🙏🙏
Thanks dear
Nice and very useful 👌 video. I love your innozant channel ❤. Pls keep it up in future.
Thanks Kapil Ji..Happy Learning dear ❤️❤️
Keep Teaching you are doing very well job thank you
Maza aa gye dekhke 🙏🙏
Really sir you brilliant teacher .
Thanks Raghav ji❤️🙏
You are amazing sir 👌
speechless sir...!
Great Sir...So kind ..Great professor. thanks and regard.
Very Good Sir simply understand
Thanks Sunny ❤️👍
Very beautifully explained !
Thanks Jaishri,Must Watch Pivot Table Options video uploaded now,You may like it
Now I can extract text from a string using Left Mid and Right functions.
Thank you.
Thanks Dear❤️❤️👍
Useful function and effective video..
You are really great sir
Thanks Dear..Happy Learning
Good morning sir
Good Morning dear .happy learning
I di the exact thing Nested Find before you taught it... Thank you sir
Looking forward to your mail regarding the assessment...
👍👍🙏❤️which mail Anurag Ji?
@@Innozant you told me I'll tell if something comes up for MIS executive post... When I told you I know advanced excel, SQL, Tableau but couldn't find job...as I'm fresher for 2 years...
My mail ID is anurag14pro@gmail.com
Ok .For MIS opening,you need to clear our assessment test to get Interview reference
sir really , really , thanks to you sir
🙏 JAI HIND SIR🙏
Sir jese apne 1+ karkr next space par puch gye the +1 ki jagah +2 karke uske bhi aglr space par puch sakte he
thank to you for your support so that we can learn more about excel. one question which trouble, how find duplicate and solve like this data - contact no . 100 rows in a sheet, one, two ,three mobile no in sequent may be repeat one mobile no in three time
I have learnt a lot from you sir, I wish I could afford your fee.
Thanks dear...No issue,You may learn from Innozant channel,Complete course is there..Happy learning
@@Innozant thank you so much sir
TQ...SIR....🙏🙏
Tq sir ❤
kiya baat hau guru aaap ki aj tak kabi nhe dekha tha ye chez
Thanks Dear...Seekhiye ache se concept ..
Abi b confused hoon m dourbra try karunga kiyn k use tu kr laita hoon aaap k le lecture ko par meri life m ye use nhe hota hai ..Bar bar bhool jata hoon ...Phir muje dil say ye he fell hota hai abi tak kuch nhe sekha bar bar nirasha ah jate hai q sir
Sir when i use search formula 3 time for 3 space its showing me only 2 time space value, if possible can you please response for understanding (Bagels, Muffins, and Breakfast) this is the format!
Sir, Great explanation... please guide if there is mixture of words like a table contains First and Last name, First Middle and Last name or First Middle1 Middle2 and Last name...how to extract last name from such table
Thnq sir so much
❤❤❤❤
Thank you sir
Nice sir!
Thank You
Sir wonderful
Thanks Mohan
@@InnozantSirji kya aap hame SQL queries sikha sakte ho
haan aayega videos sql ke bhi
Sir agar left ka nikal na h to replace ke formula me kya 2 change ho ga sir a nahi raha sir please help me
इसमें delimiter है तो text to column से भी तो ये हो सकता हैं columns extra ले लेंगे
Wow! 👍👍
Thanks Ananta,We welcome you to experience the taste of success witb Innozant-Seed of Success.
wow sir thanks
Sir, I have 3 underscores in my data, m unable to extract the right with right function..please help..My data is as below, Acct_No_Project_123456789
Very nice
Sir kisi ek date diya hua h us date me ki month me kitne days the ye kese find kr skte h??
good sir ji
Sir chahte Hain ek hi cell mein
Text likhe cell ka size wahi rahe aur
Text size chota hoke usi me dike pura
Text(text jahe jitna likhe ) thank you
Sir please make ai use in excel related videos
sir, how to find & delete a line inserted in a cell with the help of Alt+Enter in excel. Kindly respond
Help of Atl enter?
Alt enter is used to insert multiple line in a single cell
@@Innozant Yes! i have large data having some extra multiple lines & i want to delete all of these extra lines, because i am facing much trouble to handle it.
SIR when we are doing copying its very east but when we are trying on our own it difficult , Practise practise and practise,,,, he continuous practise se aa jayena na i am preparing for MIS ,in our organisation opening are coming continous . want to crack this time anyhow
sir love you , sir
Hello sir
After evaluating formula with F9
How we can get actual formula again
Undo-ctrl z
@@Innozant maine kiya tha but wo apni actual form me nhi aya
To fir copy v nhi ho raha tha formula
Sir is it compulsory to use len() funcn while using right funcn or can we find it only by right and find funcn.
yes we need to use len as right function extract data from right to left
@@Innozant and sir why not we use len in left funcn
there is no neer to use len thete az it extracts text from left to right
We can use =right (a22),Len(a22)-find(" ",a22,9)) and press enter
Thanku sir
Thanks Pawan Ji❤️
When we have text to column method so why we are using this method ?? Is it important in real job or we are just learning this method ???
Mohit Ji Text to column or flash fill is one time solution only ..It is not a permanent solution as formula do.
Sirji how to find the 3rd space in the text I tried its giving error.. pls help
launch video.
wp traditional method se nhi hoga
@@Innozant hi dilipji any update on this topic
What short key is use to check the value of any फार्मूला?
F9 is use to evaluate
@@Innozant and for again come on formula what short key is use boss.
Agar replace se Karuna ko kese nikalu ga sir
Dear Sir, suppose my name Anish Kumar Yadav , to find yadav =right(old txt,find(" ",oldtext)+1) here also bring me the last name, i am a learner, still now i learn every thing from you , is this formula right
Sir, i mean -1
Replace se kr lo .
=REPLACE(old_text,1,FIND(" ",within_text,FIND(" ",within_text)+1),"")
"fuad mohammad khorshed alam " here is my name so what will be the formula for the first name and last name
please sir help me
I am unable to find initial of last name. I need initial of first,middle and last name.
sir kisi ka sir name "anshu ram" use condition m y formula m error aa rha, Y only us condition m le rha jab kisi ka last name "ansu aman sood" ho tab y last wala le rha h. mujhe aisa chaiye ki agar kisi ka name eg. rahul kumar, ya rahul kumar roy us condition m mujhe last name chaye bas
Excel maharaj series dekhiye aap..mil jayega solution aapko
Sir please mid formula ka use karke mid name ko extract kariye please sir
Iska next video dekh lo
Hi sir pl suggest if We have date Like this so how can find the output.
Data
The cost USD Is 100
His Score is 79
Item core is 14258
Ticket number is 1245
We just want Numeric part and Text part both should be individual row and columns.
Formula use Karna chahte Hain ya tool..?
Tool se to bht simple hai text to column ya flash fill use kr lijiye
@@Innozant sir Maine sab try kar liya ha tavi tho apko approch kiya ha
Agar sir hamare pass 10 name hai , jisme ki koi 2 words or koi 3 words ka hai or hame right name sirf nikalana hai , to kaise nikalenge
Will make video for the same in text maharaj..usimg left substitute and iferror we can easily do this prob
@@Innozant will wait for this
Sir ,jab output basically Lana hai minus plus karke hin, toh fir Left Right Mid in teeno ka kya sense hai mujhe nahi samajh aa raha hai!! Sorry sir aapke itna acchhe se mehnat se samjhane ke baad bhi mujhe fir se aapse puchna pad raha hai !!
Phirse dekhiye ek baar video dear..aayega samajh..
@@Innozant sir mera kehne ka matlab hai ki ek certain length mei se ek certain length ko subtract hi toh hum kar rahe hain aur jo bach gaya wo humara output hai , fir isme Mid kya role play kar raha hai !koshish karta hun fir se samajhne ki thanks!!
Sir I have a doubt. मेरे पास एक लिस्ट है. Names की. जिसमें से मुझे first and last name अलग करने है. Left and find formula लगाने के बाद मेरा first name to अलग हुआ. Magar जहाँ - 2 list में only ek hi name है. वहाँ error show हो रही है. तो मुझे फिर अब कौन सा formula lagana hoga. Kindly send me syntax of formula.
iferror lagske null pass kr dein..jahan ek hi name hogs wo blank kr dega
@@Innozant sir par hme blank nhi chahiye wo single name bhi to chahiye as a first name.
single name to aayega hi ,iferror to bus jahan error aayega uske jagah null
@@Innozant sir jaha single name है. Whi to error aa raha hai. Send me ur WhatsApp no. I send pic. File.
Sir, how to Converting a number (1,2,3) to a string (one, two, three)
Om soon coming with this video with explanation step by step🙏🙂❤️
Sir Please upload video math function
Sir एक वीडियो बड़ी संख्या पर भी बना दो
50000/60000=60000
40000/20000=40000
Sir Gmail I'd se example krwaun please 🙏
Sir apne 1 hi questions solve kiya..phir ek hi click me baki automatically kaise solve ho gaya??
Matlab?query phirse puchiye dear
Bro formula ek hi cell me lgta hai baki drag down krte h to automatically sb solve ho jate h
❤🙂👍
🙏🙏🙏
Sir,, can I solve this problem with the formula of substitute...??
Excel sheet ka link de Diya kro ji
Diya gya hai maste link
Address main se pin code kaise alag Karen
Address Ka for Kaisa hai wo bataiye
-?????? use karke kyunki pin code hamesha Dash(-) ke saath use hota hai , you can give it a try
Sir please isko explain ki ji ye...isko kaise kare...Pahle item details then item code
Example
39258 calc = 0001
39258 calc red = 0002
Lekin order aaya hai
39258 red 120 chk calc
39258 regular calc
In this case how to find the exact item code
In order details
@innozantofficial telegram id par share kren query
1) Neha Iyju (IV/A) how to separate in exel
NESTED FIND SAMAJ NHI Aaya
aap ke voice echo maar raha hai
8 se 10 barr video ko dekha tab jaake samjh aya hai mere k find ko nested ku kar rahe the aap... Apne asal me kara kya hai.. Jo start number hai na uski jagah pe apne ek or find chala diya +1 add karke jisse k wo doosre space par pahuch gaya..ab jaake samjh aya hai😂😂
👍
I have a query regarding replace formula that is-
I use replace formula as below:
1000-33 replaced with 1000-033
1000-1 replaced with 1000-01
But want
1000-1 replaced with 1000-001
So I want to know how to use one replace formula or another adding formula which make the series of the Numbers
THANKYOU SIR
Thanks Rajesh ji
"fuad mohammad khorshed alam " here is my name so what will be the formula for the first name and last name
please sir help me
"fuad mohammad khorshed alam " here is my name so what will be the formula for the first name and last name
please sir help me
"fuad mohammad khorshed alam " here is my name so what will be the formula for the first name and last name
please sir help me
"fuad mohammad khorshed alam " here is my name so what will be the formula for the first name and last name
please sir help me
"fuad mohammad khorshed alam " here is my name so what will be the formula for the first name and last name
please sir help me
"fuad mohammad khorshed alam " here is my name so what will be the formula for the first name and last name
please sir help me
"fuad mohammad khorshed alam " here is my name so what will be the formula for the first name and last name
please sir help me
"fuad mohammad khorshed alam " here is my name so what will be the formula for the first name and last name
please sir help me