Issue formatting Date and Time Format, remove the 'T'

[MAP77]

Hi all.
I have thousands of rows of interval data where the date/time column is written like this: 2020-10-26T00:00:00. I would like the data to read dd/mm/yyyy hh:mm:ss. I tried doing a custom date and time format as per my requirement but it wont convert it. The 'T' in the original data seems to be the issue. If I delete the 'T' and then apply the custom date and time format, it works.
Any idea how to do this in bulk?

 

[RoryA]

You could try using Find/Replace and replace the T with a space?

 

[MAP77]

You could try using Find/Replace and replace the T with a space?

Interesting. I did try it. Seems to work ok if you replace one at a time. If you hit 'replace all' it doesn't replace any of the ones in these columns but removes all the 'Ts' from the column headings.

 

[MAP77]

FYI. I have just discovered that using the replace function is the tool I need to do this