have the following data extracted & now sitting in excel all in one cell
tue 06 oct 2015 05:45.00 pm utc
wed 07 oct 2015 04:22.00 am utc
would like to really have the data structured as [ day] [ date ] [ time ] [am/pm] [ utc]
in order to do analytics on a very significant volume !!
the other fields of data have come across ok / useable - its just the above is all in one column
** help / guidance from power users much appreciated **