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

Thank you,

"Bob Phillips" wrote:

Try it and see, you might be pleasantly surprised.

--
HTH

Bob Phillips

"Jordan" wrote in message
...
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.