converting date automatic conversion

[willhelmx]

Hi guy´s

Trying to find how to change a space to tab in the search replace function

Why, because i have a problem when importing .csv date format

i get from import date as 17-04-2020 18:49:32 with a space, and i cannot for the world find

a) can this be converted automaticly

b)  if not  how to search replace change the SPACE to a TAB in a column

[#2]

@willhelmx 

Depend on what you'd like to receive. If your system date format is dd-mm-yyyy, Excel shall convert correctly the string into datetime. If not, you'll have not transformed texts. If only date is needed or separately date and time, you may Data->Text to Columns it adjusting date format on the third step of the wizard.

And if csv is imported by Power Query all such transformations could be done with it.