How about using a bunch of Edit|Replace's?

Tim wrote:

Thanks that seems to work but can I tell it to go through the whole sheet and
wherever it sees orange put 3
--
Tim

"Mike" wrote:

Put this in A5
=IF(A3="Orange",3,"Not Orange")

"Tim" wrote:

I have a cell ie. A3 which is a word and I want to tell cell A5 that whenever
it sees this word to asign it a value of 5 foe example.

Orange=3

Is this possible
--
Tim

--

Dave Peterson