changing the values in a calculated column
|Food||Food (ideal column)|
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')