Assume:
Full name (Abbott, Susan H.) is in cell A2,
First Name formula is in cell B2.
Last Name formula is in cell C2.
Middle formula Initial is in cell D2.
B2 =LEFT(A2,FIND("~",SUBSTITUTE($A2," ","~",1))-2)
C2 =IF(LEN(A2)-LEN(SUBSTITUTE(A2,"
",""))>=2,MID($A2,FIND("~",SUBSTITUTE($A2," ","~",1))+1,
FIND("~",SUBSTITUTE($A2," ","~",2))-FIND("~",SUBSTITUTE($A2,"
","~",1))-1),RIGHT($A2,LEN($A2)-FIND("~",SUBSTITUTE($A2," ","~",1))))
D2 =IF(LEN(A2)-LEN(SUBSTITUTE(A2," ",""))>=2,RIGHT($A2,LEN($A2) -
FIND("~",SUBSTITUTE($A2," ","~",2))),"")
Watch the wrapping in this post.
--
HTH,
Gary Brown
(e-mail address removed)
If this post was helpful to you, please select ''YES'' at the bottom of the
post.