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.
--
Gary's Student


"Subu" wrote:

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