If statement using "begins with"

[bethemt]

Hello,

I am trying to write a IF statement that uses the criteria "begins with".

Ex: IF (Cell "A") begins with "7" then return "Hickory" otherwise return "Florence"

Essentially I want to say that if the vendor number begins with the # 7 then list the city as Hickory, if not list city as Florence.

Any help is greatly appreciated

 

[AlanY]

try

=if(left(A1,1)=7,"Hickory","Florence")

 

[JessyD]

Hello,

Try this formula. Change A1 if needed.

=IF(LEFT([COLOR=#ff0000]A1[/COLOR],1)="7","Hickorey","Florence")

 

[mikerickson]

Or

=IF(FIND("7", A1)=1, "Hickorey", "Florence")

 

[bethemt]

Perfect!!! Thank you all