Finding initials from a full name

  • Thread starter Thread starter HS
  • Start date Start date
H

HS

I have a cell that contains someone's full name
"John Doe" I need to know what function or formula I
could create to populate another cell with the person's
initials "JD".
 
This works in your example, but may not work in all circumstances.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Hi HS!

This covers from 1 name up to three names:

=IF(LEN(A14)-LEN(SUBSTITUTE(A14,"
",""))=0,LEFT(A14,1),IF(LEN(A14)-LEN(SUBSTITUTE(A14,"
",""))=1,LEFT(A14,1)&MID(A14,FIND("
",A14)+1,1),IF(LEN(A14)-LEN(SUBSTITUTE(A14,"
",""))=2,LEFT(A14,1)&MID(A14,FIND(" ",A14)+1,1)&MID(RIGHT(A14,FIND("
",A14)-1),FIND(" ",RIGHT(A14,FIND(" ",A14))),1))))

If you only ever have two names:

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


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top