use replace command to change the contents of formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can the "edit replace" command be used to replace text contained within
formula's.

I have a worksheet with many many rows of formulas all of which are linked
to another worksheet. All of the formula's look something like:
=OFFSET(gl0910admin!$A$1,MATCH(4500411,gl0910admin!$A$2:$A$2000,0),7)

I want use an edit replace to reporduce the entire set of formulas but
change the worksheet source name. (the word admin would change to sales)

Thank you.
 
Hello Bob & Naz,
I tried again and found that i could only use the replace function if the
cell is not highlighted.

Thank you,
 
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 a value within a formula 2
Global replace a reference to a worksheet 1
Use a wildcard within edit/replace 4
Replacing using a wildcard 2
Use Find and Replace in Excel 2
Replace a portion of a formula 2
Changing multiple worksheet references in formulae 2
Find and Replace error 3

Back
Top