Find/Replace Text In Cells

[Guest]

I know this can't be that difficult.. How can I change the word "APPLE" to
"Orange" in all my cells.

I try to do this and I keep getting the message "Data Can't be found" - I
see the data in the cell.

I am doing Find/Replace --> Replace All..

Thansk Rob

 

[Guest]

Well it works for me. Of course I just typed apple in to cells and tried it.
The word APPLE would have to be text in that cell, not a formula whoes result
is APPLE