Formula Help
 

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

Hi
=LEFT(A1,1)

--
Regards
Frank Kabel
Frankfurt, Germany

Zorro wrote:
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