5 Secret Tips for Text to Columns in Excel 

Best teacher for sure, no matter the subject.

YOU ARE PERFECT!

Thank you Alan.

Very Helpful !

Fascinating!

great video ♥

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

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

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

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

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

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

Great Sir thanks a lot💕🌷

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

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

You are the BEST

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

thanks

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

Very informative. Thanks

Very useful and helpful Many Thanks

very usefull Thanks a lot

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

Wow

Thanks 👍

Thanks very useful

Very informative!

Cool stuff.