=IF(LEFT(B2,2)="SP","Supply","")
--
-SA


"Phil G" wrote:

I'm programming a bunch of IF statements into a spreadsheet.

The statements take the text of one cell and post a formula result in
another cell, such as: IF B2 = "SP-129", B3="Supply"

I was wondering if I can have the formula just key off of the first two text
charachters in the cell, shortening it to something like: IF B2=SP..,
B3="Supply"