Yes, and you gave perfect easy to follow instructions. Worked like a charm!

"Ragdyer" wrote:

If all your data is in the same format as you posted in your example, you
can use TTC (TextToColumns).
You should realize however, that April has *only* 30 days.

Select your column of data, then,
<Data <TextToColumns <Next <Next
Click on "Date", and make sure that
YMD (your *present* configuration)
shows in the date box.
Then <Finish.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Leigh" wrote in message
...