Hi all,
I am currently archiving some old SMS messages from iPhone.
By default, the time and date of each message is recorded in one cell as "yyyy-mm-dd@hh:mm:ss", for example "2014-03-11@21:56:22".
Is it possible to reformat this data into something more readable, such as "11th March 2014, 9:56pm"?
Thanks in advance.
Bookmarks