I'm exporting a long list of timestamps from the online form software Wufoo as a CSV. The date and time information appears in a single cell in Open Office as follows:
I would like to split this content into two cells, date and time, so that I can reference the content individually. I've tried the following:
Strangely, if I change A2 to:
then the above formula works to split the cells, but provides text as opposed to usable data.
It is also important that this is done as a formula rather than a command, as this will be repeated many times and should be automated.
Thanks in Advance