View Full Version : [SOLVED:] Get Initials...
johnske
01-07-2005, 01:52 AM
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
01-07-2005, 02:12 AM
Try this:
=LEFT(A1) &MID(A1,FIND(" ",A1,1)+1,1)
johnske
01-07-2005, 02:22 AM
Thanx muchly Jacob,
That's heaps simpler than what I'd been looking at... :yes
John
Jacob Hilderbrand
01-07-2005, 03:07 AM
You're Welcome :)
Take Care
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.