Say a formula (=C3+C4) was already present before this across the board
change from Ss to Cs took place. When you change Cs to Ss this formula will
also change to =S3+S4.

Alok Joshi

"Biff" wrote:

Hi!

It's my understanding that this is what happened to begin with.

The OP wanted to replace some "S's" with "C's" and *ALL* of them were
changed. Why not just reverse that to get things back to where they were?

Biff

"Alok" wrote in message
...
Some Cs which were originally there will also change to S and hence this
will
not work.

Alok Joshi

"Biff" wrote:

Hi!

Why not just reverse the Find/Replace operation: Find "C" replace with
"S".

Messing with the registry and changing undo levels costs memory!

Another possible option: Close the file without saving

Biff

"Jane" wrote in message
...
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