Rearranging Data in each cell in a Column

[Revier]

Hi

A bit of background
An automatic report I receive displays the date and time in a weird way:

19/08/2006 19:11:13
YY/MM/YYDD HH:MM:SS

is there a way to rearrange this data to a more usable format?

 

[DanteAmor]

The data stored in the cell is as date or as text?

What format do you want?

 

[Rick Rothstein]

Hi

A bit of background
An automatic report I receive displays the date and time in a weird way:

19/08/2006 19:11:13
YY/MM/YYDD HH:MM:SS

is there a way to rearrange this data to a more usable format?

Your example does not make sense... how is the YY number 19 at the beginning and 20 at the end?

 

[Revier]

its pure text al in one cell and Ideally Id like it DD/MM/YYYY HH:MM:SS
@Rick its not a typo its how the data comes, makes it hard to set a window of time using filter which is why i need to rearrange it