HI,

I have a text "Sunday 2 November 2014" in cell A19; and would like to change it to "2-Nov-2014" as a date, in cell B19.
Is there any formulas available to correct the problem?

Cheers