Hi,
I have a date in excel that have extra spaces, but it is in text format because excel doesn't recognize it as date.
It is currently in this format: May 10 2016
2 spaces after May
I have tried several formulas with no luck.
=IF(ISTEXT(A1),DATEVALUE(MID(A1,1,10)), INT(A1))
Any solutions that will convert the text into date format. I actually need it in XX/XX/XXXX format
-Newb
Bookmarks