Hello,
I have values in column A, that represent the time of a data entry, all in the format:
2020-10-15T09:01:18.000Z
2020-10-14T08:16:50.000Z
With help of vba, I want to replace all values after the letter "T" by space " ", so that only the Date will be visible (and the time no more).
Preferably in column B (which is empty).
The format has to be in
15/10/2020
14/10/2020
Can someone help me out?