Problem with Find and Replace

G

Guest

In Excel 2003, when using Find and Replace it cannot "find" anything. If I
just use Find and change the "Look in" to values it works, but when I cahnge
to Replace, the only option in "Look in" is Formulas!
 
D

Dave Peterson

If you type a constant into a cell, then that constant is treated as a formula
in this situation.

But to do edit|replace, it doesn't make sense to look in Values to make changes.

If you have:

asdf in A1
qwer in B1
and
=a1&b1 in C1

Then you'll see asdfqwer in C1.

If you do edit|replace (dfqw with ZZZZ), what should happen?
 

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 6
Excel - replacing Text in workbooks 1
using find and replace it's making me look in another file to upd 1
How do I get Rid of the Circumflex Accent (Caret) 2
Find "Look in" box does not show 'values' on 'formulas' 2
Why doesn't "Replace" function find value I know exists? 3
Finding dates without attention to data formats 1
Find/Replace Select Numbers in a Cell 3

Top