Text Function in Excel in Hindi | Best use of most used text function

[@Aghast88]

Revolutionary teacher.... Great sir
I Found a Quick excelraction in my Excel knowledge within 2 months.

[@Innozant]

Thanks Santanu..Happy learning..❤️

[@Knu_804]

बहुत बढ़िया फंक्शन्स जिसे मैं बहूत समय से समझना चाह रहा था ये मुझे यहाँ मिला बहुत बहुत धन्यवाद ।

[@RiyaKumari-kf1hh]

Sir you are the master of excel😊

[@neharocksharma1640]

Your way of understanding is very good.

[@Innozant]

Thanks Neha..Keep learning.

[@sheebakhan1487]

SIR JB BHI AP SMJHATE HAI BILKUL ESA LGTA HAI JESE AP SAMNE BETHKR HI BAT KR RHE HAI ITS AMAZING

[@Innozant]

Thanks Sheeba..Keep learning

[@deepakjain-zm3sn]

Maine apni life mai aapke jaisa teacher nahi paya aap great ho

[@Innozant]

Thanks Deepak aapke itne valuable appreciation ke liye...apni skill badhane ki koshish kijiye career khud acha ho jayega

[@sandeepaswal8944]

Sir you teach so well. I learnt your all videos & daily i practice your all videos. Thanks for sharing interesting excel videos. God Bless You. Stay Healthy.

[@Innozant]

Thanks Sandeep Ji for your valuable feedback,It really motivates me to make some good knowledgeable video for all of you.Keep learning and share your friends to subscribe and learn from there.

[@sandeepaswal8944]

@@Innozant Sure Sir.. Definitely i share yours video.

[@shubhamchoudhary3786]

This was indeed a value addition to my knowledge

[@Altaf_Alam]

Thanks you sir 😊❤️ and your your background music ..which is at the end of video ....superb i like this music 😍

[@Innozant]

Thanks dear..happy learning ❤️

[@lavyyadav1487]

I respect your efforts. Thanks you.

[@Sanatan-p2j]

Great Teaching skill. You are really great.

[@Innozant]

Thanks dear

[@Pyaritapasya36]

Hello sir your videos are amazing but sir plz sheet ki file name properly provide kraye because link open krte hi bhut saari file show ho jati hai isme humari konsi file hai wo find Krna me mushkil hoti hai that's why

[@Innozant]

Playlist wise file rakhe hue hain saare dear,basic excel to advanced sabke folder me assignment hain..keep learning

[@purabmhatre3056]

Thanks sir, Very useful information.

[@princekesharwani5039]

You are great and your ideas is very helpful for us.

[@Innozant]

Thanks Rakahit🙏❤️

[@aartisinha3436]

Wow sir very useful function 👍 thanku 🙏 🙏🙏🙏👌👌

[@Innozant]

Thanks Aarti.. Happy learning ❤️

[@aartisinha3436]

@@Innozant Namaste 🙏 sir

[@mohitsharma-ym3km]

Amazing sir, thanks a lot. You are really great. You are very energetic and l never feel bore when you teach. Feeling blessed to Meet such a great teacher 🙏🙏🙏

[@Innozant]

Thanks Mohit Ji..Lots of love🙏🙂♥️Yess will meet dear

[@karankapoor200]

you are best teacher 🙏👍🏻👍🏻👌🏻

[@Innozant]

Thanks Karan for your appreciation.

[@pradeeppatwal6564]

Last option zero is new for me thanks for providing this valuable information

[@Innozant]

Thanks Pradeep Ji..Happy learning ❤️

[@gauravojha5225]

Well done... !! Very Informative Sir, I will stay tuned for more from your side. !! 👍👍

[@Innozant]

Thanks Gaurav Ji . Happy Learning.. Recommend you to start your learning journey from playlist Basic excel onwards

[@jaishrisaxena1083]

Excellent way of teaching!

[@Innozant]

Thanks Jaishri for such a valuable feedback

[@shantilalrajput8708]

Thank you sir 🇮🇳🇮🇳🇮🇳

[@premchandsagar157]

Superb sir.. 🙏

[@Innozant]

Thanks dear

[@mallukatabu6193]

really i enjoy this class full ento

[@jayantabhattacharyya628]

Dear Sir
I have watched your videos very carefully and all videos are very interesting to watch. Your way of teaching is very good and simple so that anyone can easily from your videos. I have a question Sir, in this video you told that zero is a digit placeholder. What is the placeholder for alphabet we can use in text function?
Thanks
Jayanta Bhattacharyya.

[@devmahawar2570]

Good and helpfull videos...

[@worldmemes11]

Thank you sir very helpful video

[@N6.Channel]

Nice explanation 👌

[@javedahmed8343]

Bahut hi badhia

[@sawaimalhi8439]

jai ho sir aaap ki kiya concept diya hai aaap nay tu ese concept muje udemy paid krte hui b nhe mila

[@Innozant]

Thanks dear..😘❤❤

[@learnalways7858]

Excellent. Sir macro concept ke upar bhi vdo banaie please

[@Innozant]

Layenge dear vba macro bhi

[@rajatsrivastava949]

Amazing sir

[@mahaboobhossain5076]

EXCELLENT VIDEO BROTHER

[@Innozant]

Thanks Mahaboob for your valuable feedback.Keep Learning and share .

[@rajdeepsaha9059]

Great Explanation.

[@Innozant]

Thanks Rajdeep Ji♥️🙏have a great day ahead

[@tjr1421]

Sir credit card no example k liye 0 ko double codes me rakhna jaruri hai?

[@Innozant]

Haan .format text

[@tjr1421]

@@Innozant ok

[@naeemahmedpirzada9255]

Great Sir
Iam from Pakistan Hyderabad
Naeem Ahmed Pirzada

[@Innozant]

Thanks Naeem Sahab.. Happy Learning dear🙏❤️

[@dynasticdraculagaming8668]

Sir kya aisa ho sakta hai ki agar me isi mahine ka numer likhu ( jaise Aaj 22 March 2022 hai to me agar cell me likhu sirf 22 to 22 March 2022 pura aaye wahi uske niche Wale cell me sirf 28 likhu to 28 March 2022 aaye aise March mahine ka koi bhi number cell me dalu to uska pura date aajaye

[@sadashivkage3133]

TQ....SIR...🙏🙏

[@vikasgawaria5330]

Happy Holi sir

[@Innozant]

Happy Holi Vikas Ji

[@aptrends3257]

Thanku sir 🙏🙏

[@neharocksharma1640]

Thank you very much sir

[@newsandvlogs9130]

Bahut Dhanyavad

[@Innozant]

Thanks dear

[@anushreeshah9239]

Thank you sir🙏🏻

[@Innozant]

Thanks Anushree..Happy Learning ❤️

[@dpak_sharma]

Shaandaar

[@pharmacareer279]

नमश्कार सर,
क्या CONCATENATE मैं दो कॉलम मैं रखा हुआ नाम एक कॉलम मैं एक के निचे एक आ सकता है? जैसे की - ये जुड़ के आया है. वैसेही ऊपर नाम और निचे वाले ROW मैं तारीख और उसने नई ROW भी INSERT होनी चाहिए, ताकि उससे जुडी हुई बाकिकी information Disturb न हो. धन्यवाद् सर.

[@princerana6679]

Real Hero

[@virendersroha1754]

Great 👌

[@Innozant]

Thanks virendra

[@gauravbhatia7987]

Thnq sir so much

[@Innozant]

Thanks dear.🙏

[@farhanilyas12]

Thanks Sir

[@aakashkumarverma281]

Sir mis ki post ke lye best resume kese banaye pls tell me

[@Innozant]

Career guide playlist me jaiye wahan resume kaise banana hai wo bhi bataya hao aur format bhi diya hai resume ka

[@uroojahmed1568]

date and time k colum ko kese merge karengy

[@tejpalsain1507]

Nice 🌹🌺🌹🌺

[@kabitarohidas2893]

Sir ese koi Trick bataiye ki protected file kokoi delete kar nahi paye

[@merapahad5086]

Sir, how can we use TEXT function in a system generated report to change the date format.... I tried many time but still not able to change the format...kindly guide 🙏

[@avanishchandra3795]

Sir I need to know about VBA kaise karna hoga suggestion please

[@Innozant]

Will start the VBA series soon...pehle SQL aur power series kijiye .

[@avanishchandra3795]

@@Innozant do you take class so that I can start VBA if possible please tell

[@Innozant]

@@avanishchandra3795 Yes..Online Class available for related technologies

[@avanishchandra3795]

@@Innozant what the fee and how to enroll

[@Innozant]

@@avanishchandra3795 for query connect with us via whtasapp - 7065069985

[@rajalakshmir9466]

Nice

[@rajdeepsaha9059]

Great

[@Innozant]

Thanks Rajdeep ji

[@MrSunilmobilerecharge]

Thanku sir 😍

[@Innozant]

Thanks Sunil Ji ..HV. A great day❤️🙏👍

[@santoshroy7467]

sir, please guide me i want letter or number after (:) from (STYLE NAME:SAHARA DRESS
, STYLE CODE:HLB40902, Etc)

[@Innozant]

Ye to simole hsi right sur len()- fund use kr lein.

[@rinkuraj2134]

Sir u used text function for dob to know date but use this function =text(cell reference,"dddd") and when I enter I got same date 13/07/1988

[@Ramsingh-zl6ub]

nice sir

[@Innozant]

Thnks Ram

[@chanchalsharma2456]

Sir
Feb 15 2016 desired output 15-Feb-16
I used date,left mid, right but I didn't get
Help me to solve it

[@Innozant]

If it's text then using formula you may able to extract the desired output but if is a date then it won't work as it is datevalue na..kindly confirm what it is

[@mahaboobhossain5076]

WE WANT OFFSET FUNCTIOS VIDEO WITH SUM ,AVERAGE,ETC AND ALSO RUNNING TOTAL AS OFFSET FUNCTION

[@Innozant]

Thanks Mahaboob for your suggestion, Everything is planned and in queue.Will post Lookup Series no. of videos step by step

[@Innozant]

You may find Lookup with other functions combination no. Of videos soon...

[@mahaboobhossain5076]

Videos are well and understanding

[@dharmendrasuthar4342]

How to extract texts from mid space to all left or mid to all right using formula... Example... Dharmendra Suthar.... Extract "Suthar" or "Dharmendra" from the original text..?

[@Innozant]

Either use replace or with left or right function or you want to extract both in same time ?

[@Learn_withkd]

👍👍👍👍

[@MuhammadTanveer-9797]

Hi Sir Please Formula how to 21-11-2020 in "New Complain" 3days ka da "Work in Progress" aay Please thanks

[@Innozant]

Matlab kya karna chahte Hain aap..yadi 21-11-2020 ko new complain Aaya hai to after 3 days Ka date aa Jaye work in progress?

[@MuhammadTanveer-9797]

@@Innozant hi sir please your email id send me please may excel file your send email

[@Innozant]

@@MuhammadTanveer-9797 @innozantofficial telegram id

[@muzaffarali3399]

Sir 4000/6000 =6000 बड़ी संख्या को उठाना जेसे 200/100 = 200 sir एक वीडियो बना दो

[@Innozant]

Ok..Alo sahab

[@chetan1008]

👍👍👍

[@kunalbose1075]

💝

[@tarjitmalka3978]

🌟🌟🌟🌟🌟

[@user-dv6sh8oz2d]

Dear Sir,
You Totally Confused us in your Vidoes while we trying to understand your Excel Videos.
Why?
Please Tell us Simple and Slow and Your Voice also Lot of Recording Disturbance. Can you please Check.
Please Understand me i want to learn the function through videos. thatway i am tell to you please
Understand my Problem
Thank you sir

[@Innozant]

Recommend you to start your learning journey from 1st video of basic Excel onwards .. Watching Random videos is the reason of confusion

[@Rohit_kondekar]

YOU ARE SUCH A DEMOTIVER RUclips . I LOOSE ALL MY CONFIDENCE AFTER WATCHING YOUR VIEOS YOU MAKE PROOBLEM MORE DIFFICULT .....😡😡🤬🤬🤬🤬

[@Innozant]

Wo confidence isliye loose hua kyunki ab tak aapne Excel ki sahi duniya dekhi hi nahi hai dear..Jaddo wale trick dekhke lagta hoga ki sab aata hai😊
Sequence me video follow Karen ye confidence top level pe jayega aapka..m sure 👍👍❤️
God bless you .Keep learning

[@Rohit_kondekar]

@@Innozant sir sorry for my unproper lanaguage .... u r so polite 😶mai ye smj nhi pa raha agar apko data clean krnaa hai, to aap flash fill se 1 sec me kr skte hai to aap ye 2-3line ka forula lagakr confuse kr rhe ho......??????

[@dilipjha1]

@@Rohit_kondekar Dear Rohit ye main bhi janta hu ki flasj fill aur text text column se wo kaam second me ho jayega but main phir bhi recommend formula ko hi karta hoon.
Ab wajah jaaniye pehle..ki jab aap intervy dene jayenge to kya first name,ya mis name extract karne ka question aap flasj fill sw denge to interviewer bhaga dega 😊
Dear formula ka replacement koi nahi kar sakta hai kyunki formula dynamic hota hai but wahi jab aapko hire kar lega to aap flash fill use kren koi prob nhi hai

[@dilipjha1]

Isliye formula Seekhiye dear concept clear hoga usse..falah fill ke Jadoo ke chakkar me kuch nhi seekh payenge

[@tarunsehgal5789]

Thanks Sir.

[@Innozant]

Thanks Tarun Ji..Gn

[@yourchannel6024]

Great