Hello All,
I am wanting to move one of three letters from one column to another and
then make a word from it's beginning letter, i.e., F would become FRUIT.
For example:
COLUMN A COLUMN B
F,X,U =IF(A1="F","FRUIT")

This works fine if it were just F, but the comma and additional letters
indicate FALSE. I have tried "F&", "F*", "F?"

Any help would be greatly appreciated!
Bryce