Posted to microsoft.public.excel.worksheet.functions
|
|
Extract Middle Initial from Name
"Rick Rothstein \(MVP - VB\)" wrote...
....
A slightly shorter formula to do the same thing...
=LEFT(A1,FIND(" ",A1))&IF(LEN(A1)-LEN(SUBSTITUTE(A1," ",""))1,
MID(A1,FIND(" ",A1,FIND(" ",A1)+1)+1,255),"")
If A1 contains
John Smith
your formula returns "John ". Methinks it should return the last name
too.
|