Microsoft Excel Syntax Issue

[Kingsteveiv]

I have 2 columns of data

ex. Column 1
5KSS3WH

I want column 2 to look at column 1 and if the information in column 1 starts with a 5, place a "A" in Column 2.

Is there any syntax associated with this type of action?

Thanks

 

[SkipVought]

Hi,
[tt]
B1: =if(left(A1,1)="5","A","")
[/tt]


Skip,

_{[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart!}