changing the values in a calculated column

Food Food (ideal column)
Apples Grapes
Pears Pears
Apples Grapes
Berries Berries

this is a two-part question:

1. Which is the best-calculated column approach for this?

     I need to change 'Apples' to be 'Grapes' leaving the rest alone.

2. I and I might as well ask in case they want multiple values also. (e.g. maybe they want to change 'Berries' to 'Oranges' and 'Pears' to 'Oranges')



(1) Answer