A colleague of mine asked me how to do this and it sounded pretty simple. However, it proved to be a little tricky - though eventually he found a lengthy work around. Just wondering whether there is an easy way to do this.

He imported a set of data into an Excel spreadsheet where the date appeared as such:

Jan 3 2013 12:00

So: month, a double space, the day, space, time.

He wanted the date in the cell to read like this (in the UK format rather than the US):

03/01/2013
(day/month/year)

Eventually, using a combination of concatenate and trim to get rid of the spaces, he was able to do this. But just wondering whether there was a much simpler way that we might have overlooked? I believe this is something he will need to do again in the future.

Any help would be greatly appreciated!