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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find and Replace Command 2
Find & Replace Options 4
MS word Find and Replace using Regex - Help required 0
Find and Replace error 3
Use Find and Replace in Excel 2
Find and Replace looking for values 1
find and replace 1
Find and replace a value within a formula 2

Back
Top