Formula Help

[Zorro]

Hi

I'm looking for a formula which will return the first letter of a word in
its adjacent cell.
For example:
A1 contains John. B1 would return J.

I've been tinkering with Chip Pearson's FirstNameLastName formulae but to no
avail.

Thanks in advance.

Zorro

 

[Frank Kabel]

Hi
=LEFT(A1,1)