Change Text Data to Date

Hi All:

I have a problem to change text data to date. I have a variable named
graduate date indicated as

Fall 1998
Spring 2000
Summer 2000

Now I need to change Fall to 01/09, Spring to 01/02, and Summer to 01/06 or
without back slash (/). Could anyone tell me how I can accomplish these
changes? Thanks a lot in advance.

Charles

Is your spreadsheet too big to do a find/replace?

Carole O

"Charles" wrote:

> Hi All:
>
> I have a problem to change text data to date. I have a variable named
> graduate date indicated as
>
> Fall 1998
> Spring 2000
> Summer 2000
>
> Now I need to change Fall to 01/09, Spring to 01/02, and Summer to 01/06 or
> without back slash (/). Could anyone tell me how I can accomplish these
> changes? Thanks a lot in advance.
>
> Charles
>
>

Hi Carole:

I think you are right. I just forgot this. Thanks a lot.


Charles

"Carole O" wrote:

> Is your spreadsheet too big to do a find/replace?
>
> Carole O
>
> "Charles" wrote:
>
> > Hi All:
> >
> > I have a problem to change text data to date. I have a variable named
> > graduate date indicated as
> >
> > Fall 1998
> > Spring 2000
> > Summer 2000
> >
> > Now I need to change Fall to 01/09, Spring to 01/02, and Summer to 01/06 or
> > without back slash (/). Could anyone tell me how I can accomplish these
> > changes? Thanks a lot in advance.
> >
> > Charles
> >
> >