Dear Sir, The great technique you taught in this video. Always waiting for your upcoming video's having unique techniques to learn and solve the excel problems. Watching so many tutorials on other channels but your way of teaching is always found different. Daily apke aane wale naye videos ka besabri se intzaar rehta hai 🙏🙏🙏 Best Regards Mehtag
@@Innozant sir sab samajh aagya..but 1st name toh aagya formula se lekin drag karne per 2nd,3rd,4th,5th names kaise aagya..plz thora samjhaiye na sir ji drag karne se kya changin hua ki aagya aage ka sab ......😅
Dear Sir Superb text Maharaj series. I have understood easily this text Maharaj-4 because of I have watched your every video so I've no problem to understand this. However your suggestion on office 365 on web version really helps me. Thanks & Regards Jayanta Bhattacharyya
@@Innozant Sir family mai dikat aagyi thi bahut badi. Sir Thank you so much aapko yaad hai abhi bhi merai baarai mai. Sir aur aapkai videos bhula nahi hu mai abhi bhi. mainai kal sai power query ki playlist start kar di hai. aur dhirai dhirai mai cover kar luga pura aapkai pending videos. Aapsai acha aur guide nahi kar sakta. Mai bahut khush hu jo aapsai juda hu. aapka gyan amol hai merai liyai.
@@sandeepaswal8944 Thanks Sandeep...Oh Family first dear..Hope ab sahi hain sab aur aap bhi theek hain..Khush rahiye ..seekhte rahiye auraage badhte rahiye yhi wish h meri
Hi Nitin...After Basic Excel Playlist you may proceed with (Sorting | Filter & Adv Filter| Subtotal | Data Validation | Array & Sumproduct Then Lookup & Reference after that Pivot table , Chart and Finally Dashboard)
Mobile phone📱 mein tapping ka time⌚ bana clock⏰ option mein phir usko graph📈 banana hain😇 to mobile phone📱 sey vo database📈 ko computer💻 mein lakar usko split💔 karwa do fir uska graphic banva do😇😇😇 Ek digital sum ka sum single digital solution milta rahein aisa kuch batao Yehi sab karkey database📈 mein digital sum bhi kar sakte hai kya😇😇😇😇
Sir excel test main help kar denge. aaj mera excel test hua tha for mis executive profile main, but i can't clear excel test. And how can I share file plz help me sir.
Can anyone help me: I have 100 cells with data in each cell as : ABC Enterprise Ltd C145/R Nehru Tower, Near Kalkaji Station, Delhi. I want to split Name and keep address in second line of same cell.(Like we use Alt+Enter) which is the best process
Hello Sir, 1 article he 1000 words ka..or usme bohot sare keywords he different different place pr. But ab muze sirf keywords delete krna hai. So how can I delete it. And I'VE 500 ARTICLES like that... 500 articles=500 Keywords
Areeeee sirrr kya jaadu kr diye😳
Hats off
Thanks Mahesh ji❤️🙏
Ye worldwide formula ho gaya.
Best👍👍👍
Thanks Dev🙏❤️
Sir aap to Sagar me Dubkar Moti Nikal lete hai
I Salute you 🙏🙏🙏
Thanks Manoj ji❤️🙏
You are the king of Excel world.
Thanks
I had come across this formula before, but now understand properly. Now I can say very confidently that this is very easy.
Wow...that's very nice..m happy ❤️👍
Thanks sir very nice video mujhe bhut need thi is video ki
Thanks Mamta..Keep Learning
I used your different formula for this purpose,, but this one is awesome,, again hats off sir ❤️❤️
Thank you sir, there is no one here like you❤️
Thanks Ankit ji for your love and support
Learning quickly from your technique...❤️
Thanks Santanu❤️❤️
Dear Sir,
The great technique you taught in this video. Always waiting for your upcoming video's having unique techniques to learn and solve the excel problems. Watching so many tutorials on other channels but your way of teaching is always found different.
Daily apke aane wale naye videos ka besabri se intzaar rehta hai 🙏🙏🙏
Best Regards
Mehtag
Thanks Mehta ji itna pyafe comment ke liye..Mere liye sachme apke ye valuable words bht eham hain dear🙏❤️
@@Innozant sir sab samajh aagya..but 1st name toh aagya formula se lekin drag karne per 2nd,3rd,4th,5th names kaise aagya..plz thora samjhaiye na sir ji drag karne se kya changin hua ki aagya aage ka sab ......😅
Fabulous sir thanku🙏🙏🙏. Good night sir
Thanks Satish Ji🙏❤️
Dear Sir
Superb text Maharaj series. I have understood easily this text Maharaj-4 because of I have watched your every video so I've no problem to understand this. However your suggestion on office 365 on web version really helps me.
Thanks & Regards
Jayanta Bhattacharyya
Thanks Jayanta..Happy Learning 🙏❤️
Namstai sir ji. I love your video. You are great tutor. ❤❤
Thanks Aswal sahab..
Pehle ye bataiye. Aap gayab kahan hain kuvh months se....?is everything fine? Aapka to ata pata nhi bikuo bhi?
@@Innozant Sir family mai dikat aagyi thi bahut badi. Sir Thank you so much aapko yaad hai abhi bhi merai baarai mai. Sir aur aapkai videos bhula nahi hu mai abhi bhi. mainai kal sai power query ki playlist start kar di hai. aur dhirai dhirai mai cover kar luga pura aapkai pending videos. Aapsai acha aur guide nahi kar sakta. Mai bahut khush hu jo aapsai juda hu. aapka gyan amol hai merai liyai.
@@sandeepaswal8944 Thanks Sandeep...Oh Family first dear..Hope ab sahi hain sab aur aap bhi theek hain..Khush rahiye ..seekhte rahiye auraage badhte rahiye yhi wish h meri
Just awesome video 👌
Osum Sirji
Thanks Amit ji ❤️
Very great sir
Thanks Dear🙏❤️
It's magic my dearest sir
Thanks dear🙏👍❤️
So nice Sir ji
Thanks dear 👍🙏❤️
Awesome sir and thank you
Thanks Kishor❤️🙏
Sir isme jahan aapne column a1 liya hai uski jagah 1 nhi pas kr skte kya..
Kya yehi kaam small screen of mobile phone📱 mein karwa saktey hain 😇
Excel in mobile phone📱 ki ek parallel series bhi banao jo kuch baat baney
Thanks Sir
Nicest one.
thanks sir aapne to meri problem solve kar di sir again thanks sir aapke jaisa banna chahta hoon kaise kya karna joga kuchh batao sir ji
Thanks dear ..Regular rehearse.. education is never ending process..Time ke saath aap mujhse bhi behtar ho jayenge..m sure...bus dedicated rahiye
If we will not leave the first cell i.e. A1, then what will we take after the column i.e. column(?) ?
Nyc sir
Sir ji folder lock and workwook protect or unprotect bta do
Usse better drive ko ya folder konbhi encrypt kar sakte hain..
Bitlocker option active kar lein windows me hota h
Sir multiple name same name ke rahenge to unko series me kaise kar sakte hai 1
Hlo sir I had complete basic excel Playlist from this channel
What series should I opt for further course
Hi Nitin...After Basic Excel Playlist you may proceed with (Sorting | Filter & Adv Filter| Subtotal | Data Validation | Array & Sumproduct Then Lookup & Reference after that Pivot table , Chart and Finally Dashboard)
Mobile phone📱 mein tapping ka time⌚ bana clock⏰ option mein phir usko graph📈 banana hain😇 to mobile phone📱 sey vo database📈 ko computer💻 mein lakar usko split💔 karwa do fir uska graphic banva do😇😇😇
Ek digital sum ka sum single digital solution milta rahein aisa kuch batao
Yehi sab karkey database📈 mein digital sum bhi kar sakte hai kya😇😇😇😇
🙏🙏🙏🙏🙏🙏🙏🙏
🙏🙏
❤️❤️❤️❤️❤️
Hello sir i using this formula but first name not come in cell ?
Sir ji desktop pr y knhi bi folder create krne k baad folder protct ho skta h y ni agr h to kaise jo apne btaya bit lo k bo to dreive lock h
Haan bitlocker se kr lein Folder ya drive protect
Folder protect hota h kiya
Yes..usimg bitlocker kr lein
Ek row 4 mobile number ho to spitl kase kare
Storing characters in array waala concept Row Indirect waala samajh nahi aata hai kaise hoga!
Video recap kriye..aayega samjh
Logic Guru
Thanks Salil ji🙏❤️
Text maharaj video 5 plsss
Sir excel test main help kar denge. aaj mera excel test hua tha for mis executive profile main, but i can't clear excel test. And how can I share file plz help me sir.
@innozantofficiap telegram id oar share kariye sheet..
Aisa kya questions puch liya ki clear nhi ho paya aapse.
Padhai nahin karte hain aap?
Sir is Par ek video bana de plz
Ok
Can anyone help me:
I have 100 cells with data in each cell as : ABC Enterprise Ltd C145/R Nehru Tower, Near Kalkaji Station, Delhi.
I want to split Name and keep address in second line of same cell.(Like we use Alt+Enter) which is the best process
Use ctrl j in text to columns
@@Innozant it did not work in excel 2007.
Sir output only 1st column me aa rha he agar me full name next column me dal deta hu or jb ye trick use krta hu to output nai ata sir pls help
Kuch or le skte h kya??
Aap khudse alag attempt krke dekhen ohir smjhiye ki 1 hi kyu liya h yahan
@@Innozant lekin hmne column A1 ko freeze kyu nhi kiya
Sir mid use krte hi output nai aa rha he vese formula app wala use kr rha hu
Kuch galati kar re hain .again apply kriye
@@Innozant sir ye kewal 1st column me output de rha he jese hi me is ko age bdata hu output blank ho jata h
Sir pls reply
Khan,Saleem, Ali (1010602) in a single cell, using function remove (1010602) and resulf should be SALEEM ALI KHAN, please?
Sir WFM mai selection Hua mera
Great Dear Yogesh Sahani sahab
Congratulations dear...Have a great career ahead🙏❤️
@@Innozant Thank You Sir Ji
👌🙏
🙏❤️
Hello Sir,
1 article he 1000 words ka..or usme bohot sare keywords he different different place pr.
But ab muze sirf keywords delete krna hai. So how can I delete it.
And I'VE 500 ARTICLES like that...
500 articles=500 Keywords
Share your sheet @innozantofficial telegram id ..Will see
@@Innozant sry sir, but I don't have telegram I'd...
Plz share me mail id. I'll send u on that...
Very long name ho to?
Sr column 1 hi kyu liya
Kaunse ques me.?
Without password
Bit oassword bhule to ho gya kaam😀
🙏🙏🙏🙏🙏🙏🙏🙏🙏