Help with text to columns

[Dazzawm]

I have dates in the format of 10/75, 12/02 etc and I am using text to columns to split then using / as the delimiter. How do I get them to go in the cells as 10 1975, 12 2002? At the moment they are 10 75 and 12 02.

 

[JamesW]

Hi Dazza,

What format is 10/75 at the moment? Try changing this to a date format (mm/yy) and then using text to columns.

I added 10/75 into A1 (formatted as mm/yy) and did text to columns and it put 10 1975.

 

[Dazzawm]

Well this is a stage of text to columns. I started with for example

(2.2D 01/75-12/02) and I need it as 2.2D then 01 then 1975 then 12 then 2002