Need to value dates

[P D Sterling]

I do a lot of work in cleaning up mailing lists other people have
generated. When I get any date column going, I usually =Value() it, to
find out if any of the dates are bogus. Sometimes they are real dates,
and sometimes they are "08/12/2006" and they get converted and formatted.

I am confronted with a list which has the dates as "Aug 12, 2006" and
I'm trying to figure how to get them as real dates. Any help would be
gratefully appreciated.
--

Regards,

P D Sterling
Dallas TX

 

[RagDyeR]

As long as they're all in the same format that you posted, you can use TTC
(Text To Columns).

Select your column of dates, then:

<Data> <Text To Columns>,
Click "Delimited", then <Next> <Next>.

Click on "Date", and make *sure* that "MDY" shows in the window.

Then <Finish>, and you're done!
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I do a lot of work in cleaning up mailing lists other people have
generated. When I get any date column going, I usually =Value() it, to
find out if any of the dates are bogus. Sometimes they are real dates,
and sometimes they are "08/12/2006" and they get converted and formatted.

I am confronted with a list which has the dates as "Aug 12, 2006" and
I'm trying to figure how to get them as real dates. Any help would be
gratefully appreciated.
--

Regards,

P D Sterling
Dallas TX

 

[CLR]

=DATE(RIGHT(A1,4),MONTH(A1),MID(A1,FIND(" ",A1,1)+1,2))

Vaya con Dios,
Chuck, CABGx3

 

[P D Sterling]

you know, you are so right! how could I miss that!!!!!!!??
many thanx!

Regards,

P D Sterling
Dallas TX

 

[Ragdyer]

Your welcome, and thanks for the feed-back.