Extracting date from text in Google sheets
One cell contains the text below:
Immediate_TAA_BRC 02/01/2021 12:30 PM-02/01/2021 9:00 PM
How do I extract only the first date: 02/01/2021
I have tried with SPLIT(RIGHT functions but it returns some weird year in 19th century...