I highlighted a column that contained a simple formula in a very large
spreadsheet. I used REPLACE function to replace the cell locations in the
formula so that I didn't have to re-type the formula with the new cell
locations.

I wanted to change the formula from =SUM(S6:S20). I wanted to change the
formula to =SUM(C6:C20). I used REPLACE to do this before.

THIS time, the REPLACE function changed cells - formulas and text - outside
of my highlight resulting in ALL of the S's on the spreadsheet to a C. ex.
the word submit was changed to "cubmit" and any formulas with a S cell
location changed to a C cell location.

any thoughts?

thank you in advance! jane