Find and Replace in Values

S

Serge

Is it just me, but when I goto Edit->Replace the only
option to select in 'Look In' is 'Formulas'.. I need to
look in Values not formulas.
How?

Thanks.
 
D

Dave Peterson

If you want to limit your range so that only values are changed,

you can select the whole range you want
edit|goto|Special
Click on constants

Then do your edit|replace against the subset of your original range.
 
Top