Namstai sir ji. Sir ji aap kaisai excel tutor mainai aajtak nahi dekha. You are very unique. Muje yakin hai mai aapsai shikhkar mai apni life mai skills develop karuga. Bhagwan sai dil sai paryer karta hu aap hamesa khush rahai.
Sir u have really expert level knowledge. Agar aapke paas flash fill na ho toh. Ye kaam aayega. Or koi formula dekhega toh chok or jayega. After 3 videos i subscribed ur channel 🙏🙏🙏
Hlo sir gd evening..sir kal.mera MIS EXECUTIVE ka interview hai kya kru mtlb kon kon se topic ki tyarri kru, kush smjj me nhi aa riha plz tell me kon se topic imports ne
Best of Luck Raman..Lookup ek baar go through bkar lijiye..countifs and pivot... Ghabra ke interview mat dena..aaramse nikal jayegam Interview me aasan ques aate hain.ydi apne mera course kiye hai aur practice ki hai to isse bahar se aa hi nhi skta ques
Dear Sir Again superb tutorial. It's like a recap as you uploaded a video earlier on how to extract numbers from text. This time only mobile number. I think this question can be solved by power query. Thanks & Regards Jayanta Bhattacharyya
@@Innozant sir jaise apne subtitute lga k text ko alg kia agr hmare ps new text na ho to hum kese krenge example :- Sandeep847383 isme se Sandeep ko find krna h to subtitute se kese krenge
Sir agar mobile number middle me ho and starting me ho and email I'd kuch k last me hai , kuch k middle me hai , kuch k starting me ho. Isme se email I'd and phone number separate coloumn me Kaise karenge. Please iska Ek formula mujhe Bata dete , manually me kafi time lag raha hai
I have worked on basics well enough sir but still none of them are helping me understand these types of solutions like extracting text or numbers from mixed data even when you are giving a thorough explanation on everything! How can I get through it Sir ?
Yes you are right...kaam krye time flash fill and text the column is fine..but interview me use nhi krne deta hai na..wahan to fornula hi lgana hoga dear
![[UNCUT] เก็บ "สจ.โต้ง" เอี่ยวมาเฟีย รู้ตัวคนบงการ ก่อนสั่งลั่นไก I คนดังนั่งเคลียร์ I 13 ธ.ค.67](http://i.ytimg.com/vi/o-J_p62D40w/mqdefault.jpg)
श्रीमानजी, आपके क्लिप्स देखकर नई नई ideas आते हैं.
गुरु पूर्णिमा के अवसर पर आपको हार्दिक नमन.
Thanks
I really appreciate your efforts on knowledge sharing. It really helps people who need the most. Thanks for your good work.
Thanks dear..m trying .Hope it helps.Happy learning dear
Samjhaate bahoot badhiya ho re 😂❤ kudos ! Great and easy explanation
Thanks Gupta Ji...never stop learning ❤️
He is the best teacher ever seen.
❤️❤️❤️🙏
Namstai sir ji. Sir ji aap kaisai excel tutor mainai aajtak nahi dekha. You are very unique. Muje yakin hai mai aapsai shikhkar mai apni life mai skills develop karuga. Bhagwan sai dil sai paryer karta hu aap hamesa khush rahai.
Thanks Sandeep ji aapke itne valuable feedback ke liye..Meri humesha wish hogi aap life me bht aage jayen apne career me.
Easy hai 😊
Sir u have really expert level knowledge. Agar aapke paas flash fill na ho toh. Ye kaam aayega. Or koi formula dekhega toh chok or jayega. After 3 videos i subscribed ur channel 🙏🙏🙏
Thanks Vishal ji for your valuable comment..hipe apke life me ye value add kar pa re h..happy learning,Have a great career ahead
Sir, Every time like your videos.
❤️❤️
Excellent, your teaching is very nice, i learn much more from you ! thanks for sharing !
Thanks dear ..keep learning ❤️
Hlo sir gd evening..sir kal.mera MIS EXECUTIVE ka interview hai kya kru mtlb kon kon se topic ki tyarri kru, kush smjj me nhi aa riha plz tell me kon se topic imports ne
Best of Luck Raman..Lookup ek baar go through bkar lijiye..countifs and pivot...
Ghabra ke interview mat dena..aaramse nikal jayegam
Interview me aasan ques aate hain.ydi apne mera course kiye hai aur practice ki hai to isse bahar se aa hi nhi skta ques
Your way of teaching is very nice, short, and fast. Your video covered many topic quickly...
Thanks dear Rammes . Really means a lot me dear🙏❤️
@@Innozant thank you sir..
Nice video sir ji 🙏🙏🙏
Thanks dear❤️
Good Morning Sir, Excellent, Sir, you are great about MS-Office.
Thanks for you, From my hart.
Sir kya sabhi number nikal sakte hai kya
Very great sir
Thanks dear❤️❤️
Thank you sir
I promoted as mis TL today , aapki hi kripa h 🙏
Wow.. Congratulations..Have a wonderful career ahead ❤️🙏
Bahut achchha sir Ji thx
Thanks dear❤️❤️
Super c bhi upper sir
Thanks Durgesh Ji 🙏🙏❤️
Thnq sir sir is type ka question apne karaya tha wo thora lengthy tha but je solution sahi hai optimize hai thq sir
Thanks Gaurav Ji❤️❤️
Thanks sir
Thanks Tejpal ji mhv a great day ahead
Sir very good and fantastic explanation
❤️❤️
Excellent work sir 🙏🙏🙏🙏. Good night
Thanks Satish Ji..Good Night❤️
Sir we can use textjoin("",true,iferror(ArrayFormula(mid(F43,sequence(len(F43)),1)*1),"")) in google sheets.
Appreciation for your work..share...how to check evaluated
Using F9
Love from Karnataka sir
badiya sir
superb, Thanks
Thanks Sweety❤️👍
Thank You so much sir
i really appreciate your efforts on knowledge sharing with excel users
Thanks Lokesh ji .god bless you dear❤️
Awesome sir thank you sir
Thanks Kishor..Happy Learning ❤️👍
Sir very important knowledge
🙏🙏🙏
Thanks Manoj Ji ❤️❤️
Nai horaha mobile nb ma agr dash ara ho sir phr kya karege
Amazing Sir
Thanks Gusain sahab❤️
my data has also - / symbol, how can i do this?
Aap jo padhate hain sir audio visual content mei uska pdf format mil sakta hai kya sir?
Complete assignment link diye gaye hain ..video description me hai link download kar lein
Mix data adreess m area age piche AA raha ho to ek fix area kese nikale colony ya nagar nikalna ho to formula kese lagaye
Nice sir ji
Thanks Sushma❤️👍
Hello sir example kp-kbr859474khr me numbers nikale nhi ho raha
Great sir 😊
Thanks dear🙏❤️
Dear Sir
Again superb tutorial. It's like a recap as you uploaded a video earlier on how to extract numbers from text. This time only mobile number. I think this question can be solved by power query.
Thanks & Regards
Jayanta Bhattacharyya
Yes you are right Jayanta.Happy Learning 🙏❤️
Jaise aap sikha rahe hai sir . Ek din aisa ayega excel thak jaega formula banate banate . Hum sab tab tak excel kar chuke honge sare formula me
Hahahaha.. Thanks Sanjiv itne pyare feedback ke liye dear❤️humlog nhinthakne wale hain dear
Awesome 🙏🙏
Thanks Kishore❤️
Sir substitute m new text n ho to kese text find krenge??
Matlab...explain kijiye kya output chahte h
@@Innozant sir jaise apne subtitute lga k text ko alg kia agr hmare ps new text na ho to hum kese krenge example :- Sandeep847383 isme se Sandeep ko find krna h to subtitute se kese krenge
Sir agar mobile number middle me ho and starting me ho and email I'd kuch k last me hai , kuch k middle me hai , kuch k starting me ho.
Isme se email I'd and phone number separate coloumn me Kaise karenge. Please iska Ek formula mujhe Bata dete , manually me kafi time lag raha hai
how to absent employees name highlight according to date in attendance sheet
Nice vedio sir
Thanks dear🙏❤️
How to format cells "ward no." 01 "ward no."01-2 this ok ward no. 01 no add but (problem "ward no." 426-8) excel please help me
Sir esko jb copy paste krte h to formula kaise hatay plz aap ak video banay Esme aap
please anyboby help me formula is not working
Which formula is not working?
Not able to solve getting #N/a for same formula over same data
Not possible..you are doing some mistake ..apply again
Can I shear you pictures
Same thing happening again
Second mid formula is taking wrong
Aap jab is number add kr rahe ho usse pehle aap ko #n/a aa raha he but mujhe value error aa raha he formula exact same he please help.
SIR WE ARE FACING ON PROBLEM PLZ GIVE ME A SOLUTION IN EXCEL MIX DATA MOVE EXTRACT EMAIL ID IN SEPARATE COLOUM
Sir ki sari videos sequence wise milengi //
👍👍❤️yes in sequence playlist h for learning ❤️
Sir apne mid function ke age -- kyu lagaya ye samaj nahi aya.
Double negative is use to coerce true to 1 and false to 0.
Concept seekhne ke liye sumproduct series seekhne
i have Data with +91 and so what is the formula
Please tel us how to separate name phone number and email id without comma
Sir i love u
Awesome 👍 video sir, sir agr hme sare digit number extract karna ho toh kese hoga isme toh sirf 10 digit extract hua hai please sir clear my dout🙏🙏
Interview cracker me already ye video hai dear❤️
Farmula not working pls help me
Why?.it's working fine kindly watch the video and apply
Ye ctrl+shift+enter sai work kra normal enter sai error aya
Kaunsa version hai apka excel?
@@Innozant 2016
I have worked on basics well enough sir but still none of them are helping me understand these types of solutions like extracting text or numbers from mixed data even when you are giving a thorough explanation on everything! How can I get through it Sir ?
Kindly start macro sir ....Thanks
Not now..after power BI seires
You can use flash fill
Abhi sahab.. interview dete time flash fill nhi formula ka demand kiya jayega na?❤️❤️
@@Innozant ha agr scenario-specific hai to formula use kare ge but fir kam pura krna hai to one can use either of them
Yes you are right...kaam krye time flash fill and text the column is fine..but interview me use nhi krne deta hai na..wahan to fornula hi lgana hoga dear
Wah
Work nhi kar raha hai
Kuch galti kar re hain aap . working perfectly fine
255 कहां से आया और उसके बाद की लाइन का क्या मतलब है वह है समझ में नहीं आया
Pehle kw videos dekhen..concept ke liye
कृपया करके जरूर बताएं
🙏👍
❤️❤️
Hi
All people who have written below excellent and all those admirable words. You all understand him Zero. Come on guys this formula is too much long
Please provide short formula to all 👍❤️
wrong formula hai tumhara sahi value nahi aa rahi check karo second row mein 1123 nahi aa raha s ke baad ki value le raha hain 9878 wali
Check formula again and rectify error
Excel k alawa kya padhate ho bhai ?
Sql , power bi,vba tableau and data science related technologies
Why is your title in English but video in gibberish? 🤦🏻🤦🏻
Bhai bakwas h kaam nhi karti
Apply krne se pehle hi ?.Works perfectly fine ..check it