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

Hi,

There should be a checkbox Match Case and/or Whole Word

Regards,
Peter Jausovec
(http://blog.jausovec.net)

"Subu" wrote in message
oups.com...
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

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

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

thanks

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

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