Hi all and thanks in advance for you help. Have searched here and elsewhere for a solution, but had no luck.
I'm copying data from another source to excel, and for certain date entries they come as text in the following format "On 14 May at 8:00". Is there anyway to convert multiple entries like this into a standard date format? With or without time is fine - just the date will do.
Thanks!
Bookmarks