Hello all,

I have cells with 2 data types in them; date and text.
The date is the first 5 characters of the cell as a serial number and then the following is alt enters and text.
Is there a way to format this cell to show the serial number as day and the remaining text as text?
Bear in mind that I refer to these cells to obtain the serial number for other formatting.

Thanks in advance,

Matt