Find/Replace Text In Cells

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

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

"Rob" wrote:

> 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