How to Split Data Into Different Columns (Comma Delimited txt File to Microsoft Excel)

[@siphiwemashaile2129]

My man... just saved me a weeks of work...

[@Retipster]

Glad to hear that!

[@Skeletonfinger1]

You just saved me 2 hours of manual rewriting, thank you!

[@Retipster]

YES! That's what I like to hear! Thanks for watching. :)

[@herbertnicholas5777]

Thank you, this was helpful. Straight on point and easy to understand. Thanks.

[@Retipster]

Glad it helped!

[@Compatible-n7h]

You have just saved me 5 hours of work. thank you

[@Retipster]

Glad I could help!

[@ajaykushwaha-je6mw]

Only because of this trick i am about to complete my month task in few days. Thank you sooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo much!

[@4urbanlens338]

Like the way you simplified it with the 3 names example too. Learnt something handy today and saved me a bunch of time. Thanks

[@Retipster]

Glad it helped! Thanks for watching!

[@shaourghauri3408]

Thank you so much for this video. I was looking for this kind of help for 5 months

[@Retipster]

Alright! I'm so glad it helped!

[@RichyFourVideos]

Holy shit this just saved me 2 days worth of manual data filtering

[@Retipster]

Alright! Glad to hear that!

[@joppev]

Thank you! Huge help. Other videos couldnt help me and I ran into some problems, but not with your approach!

[@Retipster]

That's great to hear! Thanks for letting me know.

[@QariMuhammadAbbas]

Thank You So Much for sharing this Brilliant Technique very simply! Great Video!

[@Retipster]

Of course! Happy to help!

[@yb_bakery]

Hey man, you don't know me, but I love you. Keep doing what you do - you inspire me to become an excel master.

[@Retipster]

Thanks, Yusuf! All the best to you!

[@ishanakhtar2012]

you saved me, but i figured out my data was separated by semi-colons and checked other and specified the ";" sign instead of comma... Phew! Thank you!

[@Retipster]

That's great to hear! I'm glad you were able to figure it out. Whew!

[@technicalboardhphp4097]

Great job sir , u have really Indestructible knowledge of excel......

[@Retipster]

Wow, you're too kind. Thanks!

[@princelanga8061]

Thank you!!! This was very helpful Sir.

[@mykhailokaniuk4820]

Man, You're definitely worth the Hammer of Thor!)) Thanks a LOT!

[@Retipster]

Lol, thanks!

[@shielajanetahoynon6489]

Life saver thanks a lot! I have an hour left on my activity deadline hehe.

[@notyoursmine1]

thank you I have been racking my brain on how to do this. I forgot how to do this and haven't done this in years. 104000 lines of code to go through

[@nanana_10]

THANK U SO MUCH! I'm currently doing my project about banking.

[@christianimeh8229]

Thanks so much for the video. was just what i was looking for

[@ddalton8754]

Thank you!! Life saver for titration lab lol

[@Ttn_Sounan]

It's Helpful. Thanks for the content❤

[@virajkaluarachchi4978]

I am stucked on this and now i am solved that. Thanks a lot mate 😎

[@shashwatjha9001]

Thanks a lot for this video. Precise and to the point!

[@verawilliams9135]

Thank you so much you were a life saver!!!

[@Retipster]

Glad to help!

[@lilo-hiho]

Oh my god this is the most useful video on youtube you saved me thanks🙏🙏

[@Retipster]

Glad to hear that! haha Thanks for watching.

[@yusraal-sabahi5309]

You saved my life thank you ❤❤❤❤❤❤❤❤❤

[@Shayshay98987]

You saved my day! Thanks!

[@syedrahim694]

Thanks man... Its very much helpful

[@skylarlopez-kohler7298]

This made my day, thanks!

[@mariocarvalho1392]

Thank you so much!

[@Retipster]

You're welcome!

[@mimsydreams]

OMG life saver! Thank you!

[@animeforever8508]

wow, just what i needed, Thanks a lot man.

[@miafrothingham5133]

YOU ARE A LIFESAVER!

[@Retipster]

Happy to help!

[@benjaminrawat4725]

Saved my life , thanks mate :)

[@gihanmadusanka50]

Thank you for the video. Actually that's what I'm really looking for.

[@Retipster]

Glad to hear it! Happy to help.

[@Tsr2412]

thank you so much ! it saved a lot of my time..... once again tysm !!!!!

[@Retipster]

Glad to hear that!

[@JohnKeyMusic]

Life savior! Thank you so much!

[@allRAryans]

Extremely helpful Seth ❤️🙏🏼👍🏼

[@Retipster]

Glad to hear that! Thanks for watching.

[@teohsuping5141]

Thank you for sharing.

[@irfanrahmadi2135]

thanks a lot!!!!! i've been tired for searching opening txt file method that value contains lot of comma. it always breaks into columns automatically if i directly open from excel and convert delimited. this is exacly what i need.

[@Retipster]

Glad to hear that! Thanks for watching!

[@ujwalakuramdasu9533]

Really very helpful......made task easy. Thanks

[@samahsaeed1261]

Thank you that was fast and helpful

[@deniseguilavogui2918]

Thank you so much for the video

[@pointsagencynet]

this helpful thank you😍

[@vijeys3138]

Thank you so much !!! U saved me hours !! Liked and subscribed to your channel

[@Retipster]

Awesome! Glad to hear that!

[@tonytone141]

Great video!! Thanks for the info and the help!!

[@Retipster]

Thanks for watching!

[@nobulawutwala2127]

Great Tutorial!

[@Retipster]

Thanks for watching!

[@fatsonyandoro3697]

So helpful thanks 👍

[@jagathbandara992]

thanks a lot i was very much trouble in cv data intering

[@user-bb1vl9tc9d]

Thank you so much. You are a live saver.

[@Retipster]

Glad it helped!

[@willdickens3927]

You saved my life bro

[@Retipster]

Glad to hear that!

[@GhostlyDucks]

You just saved me so much time! Thank you!!

[@Retipster]

Thanks for watching!

[@mesfindelelegn1165]

thank you so much this is very important information

[@Retipster]

Thanks for watching!

[@LeftSeatAdventures]

Just what I needed, thanks!

[@Retipster]

Thanks for watching!

[@buvanasampath3592]

Thanks a lot for this information

[@Retipster]

Absolutely!

[@coolminggt7290]

life saver thank you

[@Retipster]

Glad to help!

[@techdelivers1017]

Thankyou brother :)

[@harshavardhan5510]

Thanks for helping

[@GangsterNerd1]

Wow 😂. Thank you so much

[@Retipster]

@@GangsterNerd1 of course!

[@TheFreakingpanda]

straight to the point. Thank you.

[@Retipster]

You bet! Happy to help.

[@anissakecili]

thank you very helpful

[@colleenl3042]

Thank you! Thank you! Thank you!

[@middleclassthrash]

Oh. My. God. Where have you been all my life?

[@Retipster]

Haha... you'd be surprised how often I hear that. Happy to help!

[@aftabahmed6868]

thanks very useful video

[@md.abushama9164]

Many thanks.. Benefitted

[@praisemphafi9044]

Thank you!!! You are stars

[@Retipster]

@@praisemphafi9044 glad it helped! Thanks for watching.

[@AMT_97racing]

Thankyou for this video

[@Retipster]

Sure thing!

[@zhugeliang3905]

Please provide an example of the jumbled-up file for practice.

[@PhilRoberts-bh6fm]

This just helped the shit out of me. Thank you

[@Retipster]

Glad it all came out okay!

[@rpedro17]

Hi there, thankx for your video. i have a question, if i always have same separator rule is it possible to creat some sort of script to apply each time to the txt file that i want to convert to excel ? i mean , each month i receive 10 txt files that i have to converto manually to excel, using separators, so is there any excell rule that will do that in to a automatic way ? knowing that i know all separator numbers... thank you in advance, sorry for my english :)

[@nanjijemea4751]

life saver 🥺

[@dipenbhuva2061]

Thank you :)

[@joosttoast8714]

Great help thanks!

[@Retipster]

You bet!

[@sainathbuthagaddala5327]

loved a lot

[@ravipandey2791]

Thanks it worked

[@kondibaabhange]

It's great👏 🙏

[@leondanster8998]

Thank you man u a star!!!!!!!!

[@rogercarlsson3677]

Thanks a lot!

[@muhammedshebin9161]

Thank you man

[@Retipster]

Happy to help!

[@mfundohg958]

😭Thank you so much

[@sandeeplk8342]

Thank you so much....🙏

[@Retipster]

You're most welcome.

[@supul32]

Thank you!

[@Retipster]

Of course! Happy to help.

[@revathiathi4590]

Hi i have one data have address used comma but i want last comma only separately want any coding is there in excel

[@IDCWoodcraft]

perfect. Thanks

[@煮咸蛋]

thank you very much

[@Retipster]

You're welcome!

[@JeanKabeya-e9h]

Is it possible to do the reverse of what you did with those names? Is it possible to combine them into one column?

[@Retipster]

I'm sure you can probably do it these days with ChatGPT or Claude.

[@gilbertodesouzagoncalves6343]

Simple and objetive way

[@rebateshome9255]

Thank You Sir

[@Retipster]

Glad to help!

[@activelisting6793]

Thank you so much ^_^

[@fbergmansr]

Always wondered how to split raw data in Excel. This was great...THANK YOU!

[@Retipster]

You're welcome!

[@jeffgoldsmith9619]

You the man

[@Retipster]

Thanks for watching, Jeff!

[@mohamedshatarah7264]

THANK YOU ALOT

[@emilybernas9393]

What if it is not seperated by commas? How would you do this with Regex

[@darwingarciajuarez4739]

Totally helpful!

[@virgilio1956]

how do you import into a pre formated excel file with calculations already in it and you want to import into those columns ?

[@devonsam4297]

you prolly dont care but does any of you know a trick to log back into an Instagram account?? I was stupid lost my login password. I appreciate any help you can give me!

[@cannoncohen7038]

@Devon Sam Instablaster :)

[@devonsam4297]

@Cannon Cohen thanks so much for your reply. I found the site through google and im waiting for the hacking stuff atm. I see it takes quite some time so I will reply here later with my results.

[@devonsam4297]

@Cannon Cohen It worked and I actually got access to my account again. I'm so happy! Thanks so much, you saved my ass !

[@cannoncohen7038]

@Devon Sam glad I could help xD

[@the___f_r_e_e____guy]

How can I do it in mobile excel ?

[@atifdai313]

How to copy all excel columns into different notepad files? Suppose we have 10 columns in excel and we want to copy these data into 10 different notepad files, is there any method?

[@OriginalDemGunz]

Good video just trying to figure out the context. Assuming maybe this has been a recurring issue for you or viewers. I am an investor and have been doing office automation and screen scrapes for 15 years. Feel free to drop me a line I'd be happy to talk shop around topics like this. Take care.

[@samd8872]

My context is that for an experiment the simulator gave me an .txt with the data separaded by commas, so in order to make a graph I had to separate them in different columns

[@afe5953]

thank you

[@danishkumar5629]

where i get this type of file