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