Get Initials...

[johnske]

There must be a very simple way to do this, a command maybe?...i.e. get someones initials from a name typed in a cell.

e.g.
John Smith => JS
Bill White => BW
Phillip Donaldson => PD etc.

TIA

[Jacob Hilderbrand]

Try this:


=LEFT(A1) &MID(A1,FIND(" ",A1,1)+1,1)

[johnske]

Thanx muchly Jacob,

That's heaps simpler than what I'd been looking at... :yes

John

[Jacob Hilderbrand]

You're Welcome :)

Take Care