Reply to thread

Message: [QUOTE="Jane, post: 3563248"] 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 [/QUOTE]