Search and replace

S

Subu

Hi


I wish to search and replace all reference to column "F" in this
formula to column "$F"

However I can't run a search and replace because

- If I replace all "F" it will replace the "F" in the IF and that will
not work

- If I try to replace all *F that will again take "*" as a sort of
wildcard and vitiate the formula

any other suggestions are welcome

Regards

Subu
 
G

Gary's Student

How about copying the cells that contain references to column F to somewhere
in the worksheet such that the copied formulae now reference column Z? Now
you could use the search/replace to change Z to $F. The improvement is that
Z occurs less frequently than F in functions. I realize that this is a
work-around rather than a solution.
 
S

Subu

Since I am replacng just the Colum "F" with something else the match
case or whole words will not help

Any other ideas please..


TIA

Subu
 
S

Subu

thanks

But this is not possible always - because I end up changing other
formulae inadvertantly

so ... a request : are there better ways ?
 
Top