D
davegb
I have some spreadsheets with incorrect formulas. I'd like to replace
the existing formulas with correct ones. I can't do a fill down because
there are merged cells in the column. Is there a way to do a find and
replace to change the formulas?
I did do a search in this NG for this answer, and a found a thread
called "find and replace formulas but keep relative addressing". I
tried that solution, which was very brief, and got no results. Does
anyone know of a way to do this?
the existing formulas with correct ones. I can't do a fill down because
there are merged cells in the column. Is there a way to do a find and
replace to change the formulas?
I did do a search in this NG for this answer, and a found a thread
called "find and replace formulas but keep relative addressing". I
tried that solution, which was very brief, and got no results. Does
anyone know of a way to do this?