5 Secret Tips for Text to Columns in Excel

[@moshemaor1731]

Best teacher for sure, no matter the subject.

[@Computergaga]

Thank you, Moshe.

[@rupertrussell1]

Wow super handy. I have been using text-to-columns for years but did not know these tips thanks for sharing!

[@Computergaga]

Great to hear! You're very welcome.

[@barttitulaerexcelbart9400]

I used text to columns a lot but never for one column. Very nice video. Thanks!!

[@Computergaga]

You're welcome Bart, thank you.

[@mantomillioni3493]

YOU ARE PERFECT!

[@Computergaga]

Thank you very much 😊 You are too!!

[@afzalzamiransari]

Yes sir very nice. As you are uploading these helpful videos I will never face any problem in my office work.

[@Computergaga]

Thank you 😊 That is great to hear Afzal.

[@madandeshpande3961]

afzal is right

[@taimanchan4798]

Very useful video. Thanks so much. I didn't know how to remove apostrophe in the cell. Now I can use "Convert Text to Numbers" to sort out the problem

[@Computergaga]

You're very welcome.

[@srizki]

Thank you Alan.

[@Computergaga]

You're very welcome Sohail.

[@_mahmoudkamel4016]

Very useful and helpful Many Thanks

[@Computergaga]

You're welcome Mahmoud.

[@FunWithKids-dr2of]

Thanks 👍

[@Computergaga]

No problem 👍

[@antk7279]

Very Helpful !

[@Computergaga]

Thank you Anthony.

[@services97]

You are the BEST

[@Computergaga]

Thank you.

[@Dev_Bartwal]

Great Sir thanks a lot💕🌷

[@Computergaga]

You're welcome.

[@honeleelucero2911]

Very informative!

[@Computergaga]

Great! Thank you, Honelee.

[@JamesBond-qg5gx]

Thanks very useful

[@Computergaga]

Glad it was helpful!

[@NHABEB]

very usefull Thanks a lot

[@Computergaga]

You're welcome NHABEB, thank you.

[@m.raedallulu4166]

Fascinating!

[@Computergaga]

Thank you.

[@kirandeepchoudhry9232]

Excellent,i used this function but don't know about this unique function especially ist and second one

[@Computergaga]

You're welcome Kirandeep, thank you.

[@FRANKWHITE1996]

thanks

[@Computergaga]

You're welcome, thank you.

[@sircorn4248]

Cool stuff.

[@Computergaga]

Thank you.

[@hazemali382]

great video ♥

[@Computergaga]

Thank you Hazem.

[@backendadmin1217]

Wow

[@Computergaga]

Thanks you Abhi.

[@shukriyusofco.730]

you force me to click the like button. subscribe done!

[@Computergaga]

Great! 😊 Thank you.

[@madandeshpande3961]

Tera( yours) jadu (magic) chal gaya o jadugar ( it worked O Magician) ( This is one famous bollywood song)....I corrected my error with your trailing minus sign

[@Computergaga]

Excellent! Happy to help 👍

[@venkateshs5021]

the first coloum formate ,and next coloum auto formate how to change?

[@akash_j92]

Is there any possible way to do text to column on name which has Middle name intial in it. For eg in first name if the data is Jaiswal A, Jaiswal Akash A so in the middle name intial column we want only A needs to move rest all is there in first name column

[@Computergaga]

I don't understand the question perfectly, however you could use either Power Query or a formula combination such as MID and SUBSTITUTE. The approach would depend on the specific data and scenario though.

[@quocvietdang8118]

Tách number ra khỏi text hay quá

[@basicinfo6816]

if values are missing, in the row, how can I select the entire coloumn fast?

[@Computergaga]

If the data is formatted as a table, you can select the table by clicking the header - kzbin.info/www/bejne/aZSVlqFuZtScrKM

[@khalidfitness6533]

Very informative. Thanks

[@Computergaga]

You're welcome Muhammad.