Hello, in A1 I have a date and time shown as 201008061730 (yyyymmddhhmm). How do I get the date element into B1 as 06/08/2010 and in C1 the time as 17:30? Analystman

Hello, in A1 I have a date and time shown as 201008061730 (yyyymmddhhmm). How do I get the date element into B1 as 06/08/2010 and in C1 the time as 17:30? Analystman

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Hello

To get the date in the correct format enter the following formula in cell B1

`=MID(A1,7,2)&"/"&MID(A1,5,2)&"/"&LEFT(A1,4)`

To get the time in the correct format enter the following formula in cell C1

`=MID(A1,9,2)&":"&MID(A1,11,2)`

You can then pull these formulas down into subsequent cells.

Thanks for writing!

Thanks, it works perfectly. Steve

You saved my day and thank you…