You can split the date and time in a cell using the SPLIT function with space as the delimiter. Or in case the date and time are written using some other special characters, you can use that as the delimiter.