=IF(LEFT(A1,2)="av","avsp",(IF(LEFT(A1,1)="a","act ","hp")))

--
Gary''s Student - gsnu200906


"scootr" wrote:

A B
1 a20


I want cell B1 to read "act" if A1 begins with an "a"
or
B1 reads "avsp" if A1 begins with an "av"
or
B1 reads "hp" if A1 begins with an "h"

(the numbers in column A will always be different but the first two letters
will always be either "a", "av", or "h")

Can somebody help me out on a formula please?