It depends on if you want to keep the original date and just parse the year
from it, if so it won't work since text to columns will split it into 3
columns, the OP's subject maybe sounds like that is what she wanted but the
body of here message might be interpreted to get the year
--
Regards,

Peo Sjoblom

(No private emails please)


"wjohnson" wrote in message
...

easiest way is to got Menu Bar - Select "DATA" - "TEXT TO COLUMNS" and
then put two dividers where you want the text to split and follow the
direction on the pop-up menu


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.hightechtalks.com/m390
View this thread: http://www.hightechtalks.com/t2306725