Hello excel grand masters,
Looking for help in formatting a cell;
The cell contain the date with a space at the front " spaceD-MM-YY"

I know I can use "=Trim", however the challenge is NOT to insert another column.
I have also tried using custom formatting the cell; D/MM/YY & DD/MM/YY Etc. Etc....., it seems not to change the format.

How can I format this cell location so that when the data is copied directly into excel it recognises "spaceD-MM-YY" as a date.

If at all possible?
Without having to do extra formatting, converting, copy & pasting or other excel functionality.

All your views and replies are greatly appreciated.