Thread: Formula Help
View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

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