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.