=IF(LEFT(A1,2)="av","avsp",IF(LEFT(A1)="a","act"," hp"))
--
David Biddulph

"scootr" wrote in message
...
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?