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
|