hI
I am a beginner in excel and trying to work out a formula / function which
help me work easier and quicker. I will get straight into it.

If cell A1 = Lettuce and A2 = Orange and A3= Carrot, how do I make columns
B1 and B3 categroise these as vegetables by using a function?

I hope this makes sense
Thanks
Stadinx