Find and Replace in Values

  • Thread starter Thread starter Serge
  • Start date Start date
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.
 
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.
 
Back
Top