Click on your list, then Data Filter AutoFilter..............select the
arrow on your column and choose "Custom", and set up the windows for less
than, and 1/1/2002
That should find them for you...........then, you can replace them with
whatever text you want, by typeover or copy and paste, etc........
Vaya con Dios,
Chuck, CABGx3
"Bree" wrote in message
...
I am trying to find out if there is a way to find any dates less than a
specific date (1/1/2002), then replace all with text. Any suggestions?
--
Bree
|