With your value in A1, enter in B1 and C1:

=DATE(LEFT(A1,4),MID(A1,5,2),MID(A1,7,2))
=TIME(MID(A1,9,2),MID(A1,11,2),RIGHT(A1,2))

--
Gary''s Student - gsnu200802


"CMG8401" wrote:

I have a data series that looks like:
20080127145747 (YearMonthDayHoursMinutesSeconds)

I need to break that up into two columns
Date (Month/Day/Year) and Time (Hours:Minutes:Seconds)

Please help