5 Secret Tips for Text to Columns in Excel

In this video, we show 5 secret Text to Columns tips. These examples are not taught by others, leaving Excel users unaware of some great tips.

Text to Columns is used to split text in a cell over multiple columns. It is a great tool for manipulating text to get the data you want.

It is capable of things though that 99% of Excel users do not know. This video explores 5 secret tips for Text to Columns.

Timings for the video are:
00:00 - Introduction
00:20 - Convert text to numbers in Excel
02:00 - Convert numbers with a trailing minus sign to negative values
03:54 - Extract the first two characters
05:49 - Convert invalid date formats
07:20 - Convert US date formats to dd/mm/yyyy format

Find more great free tutorials at;

*** Online Excel Courses ***

Connect with us!

[moshemaor]

Best teacher for sure, no matter the subject.

[rupertrussell]

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

[barttitulaerexcelbart]

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

[taimanchan]

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

[afzalzamiransari]

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

[kirandeepchoudhry]

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

[venkateshs]

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

[madandeshpande]

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

[akash_j]

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

[basicinfo]

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

[shukriyusofco.]

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