You should be able to use this formula...

=--MID(REPLACE(A1,7,1," 1, "),4,12)

and format the cell to show mmm-yy.

--
Rick (MVP - Excel)


"geebee" (noSPAMs) wrote in message
...
hi,

i have values like:
DDDJun 08
in a column.

I want to know if there is a formula i can have in the next column to
convert these values to dates in the format like "Jun-08", with 08 being
the
year 2008. So for example, if the value was TWIJun 09, it would be
converted
to "Jun-09"

is there a formula i could use? or would i have to do this
programatically?

thanks in advance,
geebee