Replacing Values in Cells Via Formula

P

pclutts

I have a column in a spreadsheet with nearly 400 rows of data.
Everywhere an 'X' appears in a cell in the column, I'd like to replace
it with the date '1/18/05'. Can anyone tell me how to do that please?
Thanks in advance for any help.
 
P

pclutts

Nevermind. I figured it out. I used the Replace function. Duh! I
guess I couldn't see the forest for the trees.
 
Top