Data/ Text to Colums/ Delimited/ Next/ Next/ Date : MDY
--
Gary''s Student - gsnu200829


"Still learning@work" wrote:

I have imported employee data from an AS400. The text for dates import as
"1012008" for 01/01/08 or 12012008 for 12/01/08. Is it possible to write a
formula to insert the "/" for 4 spaces from the left and again at 6 spaces
from the left.

I need to be able to make these usable dates without speinding a lot of
time. Other suggestions for converting these to a workable date would be
appreciated.

Thank you for your help.