Excel Magic Trick 312: Extract Date & Time From Text String

What if date is like MMDDYYYY HH:MM THEN HOW CAN WE DO

Seconds are important to. I was watching this bat man cartoon were Tempest Fuget ( the clock king) said to his intern " It take aproximatly 2 minutes and thirty seconds to take these files to room 2a and back but it took you 5 minutes" and the intern was like "uh like I had to go to the bathroom" so he fliped out and fired him and went on a life long crime spree.

Saved me 👍😭

08/01/2018 is being read by excel as Jan. 08,2018 instead of August 01,2018. How to fixed this?

Great trick which has saved so much time :)

Hi Excellsfun could help me build a formula to covert the below text in mm/dd/yyyy format 

02242014
1242014
122014
2252014
1052014

Hello, Thanks for all these great videos. Can you help with the case where this is the data format? Wed Mar 21 00:35:09 2012? Thanks much.

Dear roks7223, The rule for data analysis and data extraction is; "recognize a pattern". In your example, if it is V you want, then you would build a formula to find V. If it was 1, then you would build a formula to find the 1. Always, when you are do data extraction, you have to look at all the data and find a pattern that was consistent. Any answer comes from looking at all the data. What does all your data look like? What consistent pattern is there? --excelisfun