Quick excel question

[tres]

I have a column (A) of cells, values such as:

a = 5.75
b = 6.00
c = 7.25

as text strings

I need column B to display only the first letter from column A

Any ideas for formula solution? i realise i could do it with a huge nested if function, but it's a bit rubbish!

thanks

 

[Blackstar_solar]

=LEFT(A1,1)

 

[tres]

You're awesome.

I had a nested IF string so long, baby jesus wept.

Thanks buddy