Use Text to Columns Convert Dates Stored as Text

Have you ever gotten a file and it there was a column that represented a date, but when you tried to perform some calculation with the value in the date column you get some error like a #VALUE? It's most likely due to the fact that the values in that column are text representation of the date (i.e., Monday February 19 2018 6:28 PM). Excel will recognized this as text and one indication is to see if it is left aligned to the cell (values/numbers are right aligned to the cell). If you wanted to do date calculation you'd need to convert the date text into a "proper" date value. This video shows how to use the Text to Columns feature to do that so check it out!
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltrain...
📚 Excel Books & Tech Gear ➜ www.amazon.com...
⚙️ Tools: Screencasting ➜ techsmith.z6rj...
⚙️ Tools: Microsoft Office ➜ microsoft.msaf...
⚙️ Tools: TubeBuddy ➜ www.tubebuddy....
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to www.buymeacoff...
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~

[@excelisfun]

Love the Thumb Nail Happy Face, and of course Text To Columns rocks too : )

[@DougHExcel]

Thanks Mike!

[@mmarussich3966]

That did help! Thank you for going into enough detail that I could learn how to do what I was trying to do, which was to do text-to-columns without converting the 1/12 IT port values to dates. thank you

[@DougHExcel]

You’re welcome, glad that this helped you!

[@Pankaj-Verma-]

Thank you so much for your kind help!

[@DougHExcel]

Hi Pankaj Verma...you're welcome, glad you liked!

[@Luciano_mp]

Ajudou sim Doug, obrigado.

[@DougHExcel]

Obrigado ! Ainda bem que ajudou

[@Dev_Bartwal]

Amezing technique

[@DougHExcel]

Hi MIS Dev Bartwal, thanks for the comment!

[@lazalazarevic6192]

Definitely easiest way!!!

[@DougHExcel]

Hi Laza Lazarevic, thanks for the comment!

[@mandarsonawane3914]

why is there a comma ?

[@jordansayshello1387]

Thanks.

[@DougHExcel]

You're Welcome!

[@sokcheaou3588]

Can every one run this formular in excel at 4:20 in the video
it is a silly

[@DougHExcel]

Sokchea Ou, that is very interesting...thanks for letting me know.

[@abhiseksingh4886]

If u wanna know everything about text to column. Check a video on "off to office". U will definitely thank me later.