I have some data which is provided, unfortunately I have no control over the format.
One crazy column contains some data i need to split into two columns, i can't even think how to do this...
So this is the crazy data in that column: Booked on: 20/03/2020 10:52 by: A1234567
Is there a way to Split the column so that the Date and time is joined and column named as "Booking date" and then a column called "By Who" containing just the ID at the end - ID will be a fixed length from checking the data.
I tried messing with split string, but i was hopeless
Any help appreciated.