I have values in column A, that represent the time of a data entry, all in the format:
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
Can someone help me out?