In column B I have a date showing as "14-Sep" for example and the format of the cell is "'dd-mmm". What formula can I use to change this so that it is just a text format and displays as "14 - 9". Note the spaces between the hyphen which I want added.
Bookmarks