I'm fetching data into a Google Sheet. The date column contains multiple cells with the following text string pattern:
Mon Mar 11 19:05:32 +0000 2019
The pattern always repeat itself:
[day] [month] [date] [HH:mm:ss] [Time Zone offset] [YYYY]
Can this text string pattern be turned into a date/time value using a formula?
Ideally, I'd like to split the date/time values represented in the text string above into two columns: date & time:
date | time DD/MM/YYYY | HH:mm:ss