Find & Replace values in formula

[rajtak]

Hi,

I have wrote this formula which i have applied in more than 50 columns now i want to replace the '&' with '&$'. Doing this manually in every cell is a tedious task. is there find & replace trick to solve this. Please help

=VLOOKUP($G2&J$1,$C:$D,2,0)

Thank you in advance.

 

[sanrv1f]

Did you try Find & Replace option?