begins with formula

[Pindacko]

I know someone can answer this. Is there a formula for begins with?
eg. (If A1 begins with glove b2 = a1)

Thanks

[daddylonglegs]

Not exactly but you could try this formula in B2

=IF(COUNTIF(A1,"Glove*"),A1,"")

[mikerickson]

or =IF(LEFT(A1,5)="glove",A1,"")

[Pindacko]

Thanks both of you that worked great.
This site is the best