Use Text to Columns Convert Dates Stored as Text
HTML-код
- Опубликовано: 15 окт 2024
- 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...
~-~~-~~~-~~-~
Love the Thumb Nail Happy Face, and of course Text To Columns rocks too : )
Thanks Mike!
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
You’re welcome, glad that this helped you!
Thank you so much for your kind help!
Hi Pankaj Verma...you're welcome, glad you liked!
why is there a comma ?
Amezing technique
Hi MIS Dev Bartwal, thanks for the comment!
Definitely easiest way!!!
Hi Laza Lazarevic, thanks for the comment!
Ajudou sim Doug, obrigado.
Obrigado ! Ainda bem que ajudou
Thanks.
You're Welcome!
Can every one run this formular in excel at 4:20 in the video
it is a silly
Sokchea Ou, that is very interesting...thanks for letting me know.
If u wanna know everything about text to column. Check a video on "off to office". U will definitely thank me later.