Thank you so much! You have saved our non-profit about 8 hours!!
"Teethless mama" wrote:

=IF(LEFT(A1,1)="F","Fruit","not found")

"Outlook, eh?" wrote:

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