Hi,
Hi,
If what you've posted is representative of you data then this should work. Format with a date format of your choosing.
=--TRIM(MID(SUBSTITUTE("," & A1&REPT(" ",6),",",REPT(" ",255)),2*255,255))
Hi,
If what you've posted is representative of you data then this should work. Format with a date format of your choosing.
=--TRIM(MID(SUBSTITUTE("," & A1&REPT(" ",6),",",REPT(" ",255)),2*255,255))