changing formulas

  • Thread starter Thread starter xcel user
  • Start date Start date
X

xcel user

Can part of a formula - which is a defined name for another cell - be changed
by a find/replace function?
 
Hi Stephen,
thanks for taking the time to respond. I have tried that already - i am
using excel 2003 - and excel states it can not find the data.

for example - what i want to change is =(acFebTot/a18)
to -(acMarTot/a118)

thanks again ~ Susan
 
Presumably "acFebTot" is the cell name you have and "acMarTot" is what you
want to replace it with in a formula. I have done this many times using
Find/Replace (using versions 2000 and 2003). Are you sure you didn't mistype
"acFebTot"? (I notice two typos in your reply below!)
 
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

Excel VBA 1
Replace a portion of a formula 2
Formula help = vlookup 2
Find and replace a value within a formula 2
Wildcard in the Replace function 2
Applying Named Ranges to Existing Formulas 3
defining global function to be used in multiple cells 1
Need help with a formula, please!!! 2

Back
Top