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