Excel: How To Convert Text To Dates With Text To Columns

[@robynwilson1810]

This video was a lifesaver! I've already wasted so much time and I'm glad I won't have to anymore! Thank you so much! :)

[@sherylmcguire1790]

I keep referring to this video as it is the greatest! No formulas

[@s.mr.9965]

excellent instruction Jon, I am in new position and frustrated with the way our database exports to Excel. Perfect and helpful information!

[@robertopetersen9747]

brilliant, saved an hour of entries

[@MikeWilliams-uh8ii]

This was awesome! Helped fix an issue that was causing a big roadblock in our data collection/analysis.Thanks.

[@ominisxxx]

God Your video really helps me.i already confused with this "date" thing for my recruitment test. Thank you. You are a savior.

[@NagendraKumar-kw6pj]

Well explained and saved lot of time in manually correcting

[@ExcelCampus]

Glad it helped! 😀

[@aaronfallon6738]

I couldn't figure out why doing the date format wasn't working. My goal was to be able to filter by year, month, and date. I started fixing it by double clicking each cell and I knew there was an easier way out there. Thank you so much!

[@lilladeak8550]

Thank you for this! Saved me from a huge manual work.

[@ExcelCampus]

That's great to hear, Lilla! :)

[@brianbaheramouzegarletsbui6533]

Really well done! Thank you. This was a life-saver for me downloading data from ERP, cleaning up in Excel, before exporting to Power BI for rendering and visualization. Couldn't have done this without resolving the date formatting hurdle. Thanks again!

[@ExcelCampus]

Glad it helped! 😀

[@AHDKING]

Good tip, never realized this function available in text to column.

[@FGDataPotential]

Excellent tutorial! Very clear and useful!. Indeed this problem with dates is the most troublesome for me. Many thanks.

[@ExcelCampus]

Thanks for the feedback! 😀

[@wayneedmondson1065]

Thanks Jon.. great tip. One I use in this circumstance is: Select an empty cell and press CTRL+C for copy; highlight the range of dates that are text; press CTRL+ALT+V for Paste Special; under the Operation section, click the radio button for Add; click OK. The dates in the paste range will be converted to serial numbers. The pasted range will take on the formatting of the copy cell; so, if needed, format the range to show the dates as desired. Not a better or worse method.. just another way to do it. Thanks for all the tips. Thumbs up!!

[@JOla-go1nz]

Amazing video. Thank you so much!! Saved me a load of time.

[@es8560]

Thank you Jon for the great tip. This is exactly what I need.

[@loludave9731]

Thanks so much John. Your videos are very much useful.

[@vishnubhatlavenkatasubrahm5973]

Jon, Thanks!!!!! It resolved my problem

[@MelissaMeyer-p3x]

So helpful! Thanks!

[@ExcelCampus]

Glad it was helpful! 😀

[@Lifelessons940]

Thankyou so much...u helped me solve a big issue

[@mayteo2880]

It works! Thanks a lot, Jon

[@ExcelCampus]

Great to hear that, Mayteo! 😀

[@NC-un7tr]

Thanks for the help with text to column trick. It helps

[@ExcelCampus]

Glad it helped! 😀

[@jennifergaines3123]

Thank you!!! 🙏
That really helped me out!!!

[@dishantdalvi]

Thank you

[@ExcelCampus]

Welcome!

[@pbhosale81]

Thank you! Helps a lot...

[@sherylmcguire1790]

That worked awesome thanks!!

[@allinonechannel2117]

Thanks

[@ExcelCampus]

Welcome 😀

[@leeleebel]

THANK YOU!!!! Saved me too

[@vishnu8899]

Thank you this worked!

[@roderickmose4691]

Thanks, John, useful and great as usual. keep up the good work

[@AslamJaved]

Thank you dear for your value able guidance and tutorial,

[@ExcelCampus]

Happy to help! 😀

[@nwachukwusamuel9557]

I needed this video today. Thanks Jon!

[@ExcelCampus]

Awesome! Thanks Nwachukwu! 🙂

[@husseinvirani]

You won't believe it's exactly what I was working on and viola a tutorial. *Awesome*

[@Kmissick34]

Great 👍🏿 video thank you!

[@sylvesterobo3614]

Thank you! this worked for me.

[@ExcelCampus]

That's good to know, Sylvester! :)

[@n-fspeakers4094]

Thanks- very helpful.

[@jinehbachavez28]

Thank you, it works!

[@ExcelCampus]

Great! 😀

[@sirgallahad]

Thank you!

[@thandazomsi]

Thank you. Explained well

[@imadabab]

Great video. Thanks a lot.

[@ExcelCampus]

You are welcome! 😀

[@bra9780097]

Thank you so much it works

[@lerosism]

You have saved me

[@mackobun]

I've notices that simply selecting the column (or Multiple), then Text to Columns, and then FINISH (with making any selections) completes the same task.

[@coperezroman]

Thanks!

[@ExcelCampus]

Welcome! 😀

[@adityajaysawal5868]

Thank you so much, 🙏

[@ExcelCampus]

You're welcome 😊

[@dastageera9626]

Thanks brother.....

[@Wreinie]

Perfect! This is one of the issues I have been having with a report that I have to send out. Could you do a video that will show how to change a column that is converted from a CVV to Excel where it is a TIME. I have a column that reflects when a job was assigned during a 24 hour period, but the Time is listed as Text, so my sort goes from 1-12 instead of 12am to 11:59pm. Thank you for your help!!

[@SIMRANKAUR-eg7nc]

Text ti column also coverrs this aspect. Number stored as text to proper number.Please visit channel "off to office" to know everything about text to column at one place and not in bits and pieces in different videos.

[@manin4280]

Good one.

[@ExcelCampus]

Thanks! 😀

[@karanthesmashing]

Thanks

[@ExcelCampus]

Thanks for watching!

[@lindaminde4884]

thanks

[@ranjitkushawaha904]

Thanks,,,
Bt i have face a new problem when i change MMDDYYYY to DDMMYYYY format,, using TEXT TO COLUMNS,,Few lines are changed correctly bt rew lines are remain unchanged.
Please help to fix this problem.

[@puneetvij8433]

Sir John,
Noted ! ; )

[@pawanmishra2855]

Hi which version of office you are using Please share me Name

[@DaveSan-lz5bs]

I have the date in this format
Nov 30, 2023
How can I convert the same in number form
I tried using number format, but it won't change!

[@DouglasMueller-t4n]

How do you convert "Jun 27 2023 3:01:31 PM" text date to "6/27/23" date?

[@rozario1309]

Great Videos John. When I paste census blocks-15 digit numbers into excel, it puts the scientific notation. Any idea how to avoid this?

[@anjaliraj1436]

Sir, is there any way we fix this issue in backend only or before importing from bip???

[@samvan7787]

I tried this on a Mac and it did not work. can you help?

[@alkr626]

how to fix this please 2021.01.20 16:19:43.772 milliseconds are messing with me,, i cant do replace because there is dot between dmy and before miliseconds, please help

[@chynechandran8781]

Hi, I couldn't convert a double digit date entry in the month of September to a date or number using text to column wizard.
For an instance couldn't convert September 30, 2020 to a date using text to column wizard but in the same format a date with single digit can be converted ie; September 3, 2020. Pls help

[@philmortimer1541]

Hi
Love your TH-cam channel it’s very helpful and easy to follow 👍
I was wondering if you could help me with a problem I have on excel?
I have a set of scales for our business and the data is downloaded onto a excel spreadsheet. All the weights are in rows down one column which is fine but the data comes through like this:
15 kg
12.2 kg
9 kg
and so on
To use the number data I need to get rid of the kg, is there any way I can do this without doing it one by one?
Thanks in advance
Phil

[@zhongxina8427]

Does not work if the date is in this format 2021-Dec-03

[@siyabongahlathi9514]

Hi Jon, how would one going doing this when you column date also has time (hh:mm:ss). On some the trick works on some it doesn't

[@sbuyiselosandile7977]

If it was 20230701 how do you convert that one

[@noribinios5873]

show us the opposite. There are thousands of articles showing this.

[@SIMRANKAUR-eg7nc]

Please visit channel "off to office" to know everything about text to column at one place and not in bits and pieces in different videos.