Hi all,
Have found solutions using text to columns for converting US date format to UK date format.
All good, expect my US source has time as well as date and I need it to be in UK format.
I cannot find a solution that does that with the time in the mix - can anyone assist please?
Attached is a sheet illustrating source format and desired output - would love the 3rd How column to have a solution in if possible please?
Tried a few LEFT/RIGHT solutions but that formats got all screwed up.
Can anyone assist please?
Ian
Bookmarks