use replace command to change the contents of formulas
 

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.

Yes you can
--

_______________________
Naz,
London


"Jordan" wrote:

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.

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.

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.