Problems recognizing dates from CSV import

You have an American Style date in string format, but are probably using a European regional setting. So you will need a helper column to convert it:
=DATE(RIGHT(LEFT(C2,FIND(" ",C2)-1),4),I2,MID(LEFT(C2,FIND(" ",C2)-1),FIND("/",LEFT(C2,FIND(" ",C2)-1))+1,FIND("/",LEFT(C2,FIND(" ",C2)-1),FIND("/",LEFT(C2,FIND(" ",C2)-1))+1)-FIND("/",LEFT(C2,E2-1))-1))+TIMEVALUE(RIGHT(C2,LEN(C2)-FIND(" ",C2)))

The derivation of this formula is shown in the attached spreadsheet in columns E:M. Row 3 has the individual pieces and Cell M3 is the formula with all the intermediate helper cells. Cell M2 is the same formula except that I kept replacing the intermediate helper formulas until the formula was expressed only in terms of column C.

The result will be the correct date / time, but you may have to reformat the cells - I don't know if the format I selected will "translate" into your regional settings.

On the other hand, if you are using an American date style, the formula becomes a lot simpler: =DATEVALUE(C2)+TIMEVALUE(C2)

You could use Data>Text to columns... with space as a delimiter to get the date and time in separate columns, then you could simply add the 2 columns to get the date/time value in one column.

If you have access to Power Query you could easily convert the date column.

1 Put the cursor in the table.

2 Goto the Data tab and select From Table/Range to load the data into Power Query.

3 Right click the Date column, select Change Type>Using locale...

4 Select Date/Time from the Data Type dropdown and English (United States) from the Locale dropdown.

5 Click OK.

6 Click Close and Load.