Text to Columns in Excel Part 2 | Delimited and Fixed Width Text to Columns in Excel

Learn how to extract data from one cell to multiple column in excel using Text to columns in excel in hindi. Delimited and Fixed Width Text to Columns in Excel
Download the Practice Workbook Direct Link
drive.google.c...
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
Telegram►@Innozantofficial
#texttocolumns #exceltexttocolumns#Innozant #excelinterviewquestions

[@rajkumar10gupta220]

Maine excel sikhane ke liye bahut channels ko aproch kiya par kisi ne itna detail me nhi bataya
Thank you so much sir.
UA-cam par excel sikhane ke liye best channel

[@ritikagupta5388]

Sir appne itna detail me bataya h ki ajj tak maine iska use iss tarah se nhi kiya tha na hi kisi ne aise sikhaya jab ki maine advance excel ko buy bhi kiya tha pr itna detail me koi nhi bataya thanku so much sir. 🙂

[@jaingautam74]

Apke excel sikhane ka tarika bahut accha hai. Bahut kuch apse sikhne ko mila sir. Thank you so much.

[@Innozant]

Thanks.Keep growing

[@shivamsingh6253]

I already referred my all friends to watch videos from your channel sir you are the best trleacher 🎉🎉

[@Innozant]

Thanks dear..Keep learning

[@punnuthakur7438]

Aapke vdos me unlike Jaisa kuch hota he nahi hai sir, Sab super se upar hota hai. Thanks

[@Innozant]

Thanks dear

[@janesarkhan9845]

You are great sir❤️❤️❤️❤️❤️.

[@MrSanjogbaral]

One of the best Excel learning hub - here half knowledge is converted to full. Appreciate you taking time to spread the knowledge.

[@Innozant]

Thanks ..❤️🙏Have a career ahead.Will always try to deliver awesome content that add some value in your life .Thanks for such a valuable feedback.

[@binodagarwal]

You are style is very simple than others . Very NICE

[@Learn_Digitally_Earn_Digitally]

Text to column ko ab itnaa to jaan hi gye hai ki tassali hai ki kuch behtar jaante hai... Baaki to sb dimaag kaa khel hai...
Thank youu Sir 😃

[@Innozant]

👍😊

[@sandeepchavan455]

Very nice really increase productivity

[@khalidmajeed2886]

sir zaberdast.Allah aap ko kush rakhay. taqseem kertay rahay Allah aap ko gaib saay deta rahaay ga........

[@Innozant]

Thanks Khalid shashab..Happy learning ❤️

[@sawaimalhi8439]

wa sir kiya baat hai aaap ki maza ah gya sach m aaaj ki class m jai ho aaap ki guru ji

[@Innozant]

Thanks Sawai..❤❤❤🙏🙏

[@dipak5651]

You always explain the concept in detail and that's the great quality every teacher must have. You are the special one and I really salute to your dedication. 🙏🚩😎

[@Innozant]

Thanks.Keel learning & Keep exploring

[@maddy2613]

Thank u sir...u videos are easy to understand...and ur method of teaching is perfect...

[@Innozant]

Thanks Rohit ..Happy learning ❤️

[@artatranpatra657]

You are best creation of god😊

[@Innozant]

❤️ Really means a lot to me

[@devangmehta7087]

I LIke It sir, Every new lessons are use full

[@Md.Ismail-v1e]

Good Afternoon Sir, Excellent, Sir, you are great about MS-Office.
Thanks for you, From my hart.

[@Innozant]

Thanks dear..keep learning

[@fl_d1043]

Excel guru you are to me sir 💙

[@Innozant]

Thanks

[@vikasgawaria5330]

Complete text to column tutorial video sir thankyou so much

[@Innozant]

Thanks dear

[@sandeepaswal8944]

Thank You so much sir esh video sai bahut help mili. Aapnai saarai doubt clear kar diyai.

[@Innozant]

Thanks Sandeep ji.❤️🙏

[@GNAPIKASSTEPS]

Good explanation..

[@rajnishsingh2726]

You are exceptionally good in explaining such complicated topics in a lucid manner. Salute you Sir.

[@Innozant]

Thanks Rajnish ji.Really means a lot to me dear🙏❤️Happy learning

[@mehfuzmj2789]

Thanks a lots sir.👍👍👍👍

[@cartoonloversop6019]

सर मे ऐक प्रा . ली कंपनी मे
स्टोर इंचार्ज और परचेस मेनेजर की पोस्ट पर हु जहां मुजे 3000 से भी ज्यादा मटेरियल का स्टोक मेंनटेन और हर महीने सभी मटेरियल का फिज़िकल वेरिफ़िकेशन और स्टोक की वेल्यू ओपनिंग - इन - आउट और बेलेंस स्टोक अमाउंट के साथ देनी होती है जो मे अब पहले से बहुत ही बढ़िया और आसानी से अब कर पा रहा हु और सर जो आपने मल्टी कंडीशन्स पे vlookup चलाना बताया था उससे अब मे परचेस ऑर्डर 100% Accuracy के साथ बनाने लगा हु
Thanks for Teach us 🤝

[@Innozant]

Very Good ..God bless You dear.
Never stop learning

[@GautamThinker]

Highly Appreciate you!!

[@mohinidandekar9821]

Enjoyed a lot in learning.,👌

[@Innozant]

Thanks Mohini..Gn

[@sandeepk2388]

Very nice 👌👌👌

[@satishojha6240]

Very useful video sir thanku very much.good night sir

[@Innozant]

Thanks Satish Ji..GN🙏❤️

[@gamebabaupdates9278]

Sir it is very helpful

[@pramodbhavsar4488]

Sir very nice video of text to coloum with different type example explain by you thank you

[@Innozant]

Thanks Pramod Ji.Hv a nice day ahead .🙏❤️

[@Hyyggffghhnvbb]

Awesome 👍👍

[@princysahu4181]

Sir, Your teaching is best & very knowledgeable...Thank You So Much Sir☺😀

[@Innozant]

Thanks Princy.. Happy Learning ♥️. Recommend you to learn step by step from playlist and so practice on regular basis

[@sr-m3725]

Great, i had funtime enjoying your video, u have wonderful way of explaining

[@Innozant]

Thanks

[@madhavtewary2421]

Thank U sir, for such a good explanatory video

[@sandeepsingh-jf5qb]

Sir आपकी Teaching Skill को शत शत नमन 🙏🏼🙏🏼

[@Innozant]

❤️❤️🙏🙏🙏

[@artiverma5122]

You always help me dear sir

[@sinhafication]

Thanks sir....aap to billu bhayankar nikle.....kaanta lage Na kankad billu bhayankar.....

[@Innozant]

😊

[@sanjoykumarroy3352]

You are my hero sir..I am sure one day I will get better job with the skills which I am learning from you

[@Innozant]

Thanks dear..God bless You

[@sapeduworld]

Congratulations in Advance for 1 lakh subscribers sir !!!

[@Innozant]

Thank you so much 😀.
Aapko ye bhi dhyan rakhte hain👍

[@gurpalsingh1897]

Superb !!!

[@SaifulIslam-jw8rb]

You are great

[@ramseshu110]

Thank you sir all the best 👍

[@Innozant]

Thanks Ram🙏❤️

[@kinghundred]

very good sir

[@shrikantbadge3978]

Amazing sir thank you

[@hemantgusain1260]

Thanks you sir, explain everything very well.

[@Innozant]

Thanks Hemant Ji❤️👍🙏

[@pareshparikh7944]

You are genius

[@Innozant]

Thanks Paresh Ji🙏❤️

[@onlyexcel493]

Really you explain very well sir

[@Innozant]

Thanks Nileshgiri Sahab🙏❤️

[@bishtlokesh1297]

Very well 😘

[@Innozant]

Thanks Lokesh 🙏❤️

[@md.ashrafulalam3142]

Thank you Sir.

[@imranikn]

Thank you so much

[@tejpalsain1507]

Thanks .

[@Innozant]

Thanks Tejpal Ji🙏❤️

[@arunkumarsinghark3024]

अद्भूत सर जी धन्यवाद् continues 🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l

[@abhishekshirsekar2065]

Thanks a lot sir❤️

[@Innozant]

Thanks Abhishek Ji..

[@hemgandhi8087]

Thankx

[@vivekkalshan3589]

Superb sir

[@Innozant]

Thanks Vivek ji🙏

[@rjraviraftarup7553]

Excellent 👍👌❤️

[@Innozant]

Thanks Ravi🙏❤️

[@KPS-BVM8]

Superb

[@Innozant]

Thanks ❤️

[@onlyexcel493]

I am watching your video right now sir

[@Innozant]

Great, Happy Learning 👍🙏❤️

[@L.mkidifrentlife1435]

Thanku sir jee

[@Innozant]

Thanks ❤️

[@L.mkidifrentlife1435]

@@Innozant welcom sir jee practice krte time agr mujhe kbi kuch puchhna huwa to puchh sakti hu yaha ?

[@subratagupta8244]

Just Niceeeeee......

[@Innozant]

Thanks ❤️

[@Vilasjadhav4you]

very nice

[@Innozant]

Thanks Hardik Ji...❤️

[@onlyexcel493]

Valueble video

[@sadashivkage3133]

TQ....sir

[@staterolife1651]

👍👍👍👍

[@gamesworld_all]

Thanku you sir

[@Innozant]

Thanks 🙏❤️Happy Learning 👍

[@subratagupta8244]

Please make a detailed video on Pivot table

[@Innozant]

Gupta Ji .Please watch seprate detailed playlist of pivot table is there

[@zzzzz644]

At 04:45 don't know why when trying to enter HYPHEN "-" inside OTHER OPTION as DELIMITER. It's not showing as typed there anything inside the box nor also not showing OTHER SYMBOLS (like #,@) inside it. Do I have to change any setting in my EXCEL or COMPUTER??? Currently using EXCEL 2019.

[@Innozant]

Recheck your foula may be you are doing some minor mistake there .

[@tjr1421]

I pressed insert key on my laptop and then pressed "-" it worked.

[@gumnaam6068]

yes, same issue I faced as well. @Innozant Sir, any idea why this is happening

[@neharathore7393]

Nice vedio sir

[@Innozant]

Thanks Neha ❤️

[@gauravbhatia7987]

Good sir

[@Innozant]

Thanks Gaurav Bhatia Ji🙏❤️

[@avanishchandra3795]

Nice vedio

[@Innozant]

Thanks Avanish 🙏❤️

[@rewtikashyap4834]

Dear sir,
Thanks for recorded unique videos.
Sir i have good knowledge of advance Excel and also lilte bit VBA. I wants change my job but i unable to crack interview due to communication how to improve my communication skills. Please suggest me, if ASAP.

[@Innozant]

Dear Rewti Kashyap kindly note that communication is just a medium to express,If you are technically sound no one stop you and also recommend you to start working on your communication too.There are lots of method to enhance your communication skills you may opt.

[@ishutiwari5567]

sir, jb me dilimiters me - sign lga rhi thi to bar bar mera laptop sound krra tha aur ye sign nhi lg rha tha.aur check krne pe vha koi bhi sign type nhi hora tha.excel sheet pe sign work kr rhe the but text to column me others me koi bhi sign nhi lgra tha bs vo sign wala button press krte hi laptop sound krra tha.
jb mene excel restart kiya tb ache se work kr rha tha.
any idea ki esa kyo hua hoga?🤔🙏

[@Innozant]

Hahaha..Ishu Apka excel bhi chahta hai aap text to Columns tool na use krke formula use Kiya Karen data cleaning ke liye. as such koi issue nhi hai Aisa..May b apka application us waqt stand by mode me ya respond nhi Kar Raha Hoga..🙂

[@ishutiwari5567]

@@Innozant
ok sir g 😅🙏

[@tjr1421]

Ye problem muje b hui. Fir mene laptop pe insert key hai use press kiya to (-) lag gaya.😁

[@AP-gr4ij]

Sir Tab ka kya use hai

[@RMKserve]

Super♥️❤️🇵🇰

[@Innozant]

Thanks Dear Raja.Happy learning

[@abhinavbanga2614]

Can we do text to column with specific word.

[@onkarkumar7533]

Hello sir please Assignment dijiye n

[@Innozant]

Already hai drive me .kindly check

[@theakshay9176]

Kash pehle mile hote..par abhi bhi der nhi huii..

[@Innozant]

Thanks ♥️❤️ Happy learning

[@devendrarawat7113]

गुरु जी

[@Innozant]

❤️

[@abhiinav007]

Use it with function

[@Innozant]

👍❤️🙏

[@pranjalkastwar8731]

Sir there is no practice sheet in the video??

[@AftabAhmed-uw4ki]

Sir g as mein advance option hn O's ka kia use Hy sir

[@VaghelaVedach]

I have image file and want the data in excel - text to column. Can u suggest how we can?

[@dhakafady774]

wow

[@msexcelgooglesheet374]

👍

[@Innozant]

🙏❤️

[@998bro9]

Sir , direct work book link is not working & all playlist drive mein ye sheet mil nhi rha hai

[@ruhan001]

Sir jab aapn multiple unknown contact excel me paste kre to unhe saperate column me kaise convert kr sakte h or fir unhe transporse kaise kre

[@Innozant]

Text to column se bhi ya formula se bhi kr skte h

[@ruhan001]

@@Innozant sir text to column me delimat or fixed width dono ka use hoga kya sir agar me apko WhatsApp pe msg kru to practically bta doge kya ?

[@m.rshagorahmed716]

Josh video

[@Innozant]

Hahhah.. Thanks Shagor Ahmed Sahab for such a lovely comment.🙏❤️

[@manishamanishagautam7234]

Sir aap alt a e kar rahe hai yes ya no

[@futurefoji5486]

Sir practice workbook nhi mile rhi h is link se

[@Innozant]

Assignment Master Folder ka link diya gya hai video description me..wahan se complete assignment download kar lijiye then practice

[@Forbiddenize]

can you make a video where you can show how you can convert text data into date that you have given as a question in your basic workbook practice... sheet number 18
I am unable to do it.

[@Innozant]

Students solution are there .

[@Forbiddenize]

I got it....i think it's because of the difference of version of Excel....i tried doing it on an older version of Excel and i got it done very easily

[@virendersroha1754]

Gd sr

[@Innozant]

Thanks Virender 🙏❤️

[@muhammadatifnawaz8552]

Sir!
is it possible to separate upper cell entity from lower cell and write it into a separate column by delimited or fixed width if yes then how can we separate this

[@shwetkumar1719]

sir ek bar me select krne ke lia ctrl+shift+down Arrow kia but fir se mujhe upper aana hai to kya kre ge

[@Innozant]

Ctrl + backspace

[@meditationmusic881]

sir ashish
vishwakarm
rakesh
sahu
gopi
nagwani
इन नामो को separate अलग-अलग कैसे excel मे लिखेगे जैसे
ashish vishwakarm
gopi nagwani
rakesh sahu

[@Innozant]

Char(10) apply kr skte hain..maine btaya hua hai interview cracker series me kahin

[@cartoonstory_143]

But sir Text to column me Tab ka kaha pe use karege ...............
Plz btaye...........

[@998bro9]

sir inn sheets ka link ko plz reupdate kijye , plz ,bht help hogi

[@thetruthbehind-withvipulsi4485]

Hello sir,
Is there any way to convert (26 January 2022) into date format (dd--mm--yyyy)

[@rajadey1552]

Sir me two sources se date copy paste karta hu apne work sheets pe and wo two sources ki date format alag alag hota hai... Lekin jab me date formatting karta hu wo instant format nhi hota hai. Then m every cell m jake F2 press kar kar k thik karna padta hai.... Plz koye solution batay ya apka koye vdo link provide kare plz sir 🙏

[@shwetkumar1719]

Sir yaha f4 se nhi a rhe upper

[@Innozant]

Ctrl + backspace use karen

[@HasimAli-h9w]

Sir file download Nahi ho Rahi h

[@Innozant]

Description me drive link diya gya hai