I am trying to separate the date and time in a cell into 2 separate columns. The value in the cell is Mar-25-2021 13:46:49. I want the next column to show Mar-25-2021 and the 2nd column to show 13:46:49. The split function that I normally use in Google sheets does not apply here since when I use =split(D2;" ") it just displays the same value which is Mar-25-2021 13:46:49. I don't want to use text to columns as this data is dependent on the values submitted in the form.