View Single Post
  #2   Report Post  
Carole O
 
Posts: n/a
Default

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