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