Hi
Try
In B1
=LEFT(A1,FIND(" ",A1)-1)
In C1
=IF(LEN(A1)-LEN(SUBSTITUTE(A1," ",""))=2,
MID(A1,FIND(" ",SUBSTITUTE(A1," ","*",1))+1,255),
MID(A1,FIND(" ",A1)+1,255))
--
Regards
Roger Govier
"jermsalerms"
wrote in message
...
I want to take a clients 1st and last name that populates in cell 1
and
break it apart so that cell 2 only shows the last name and cell 3
shows
only the first name.
How do I write a formula to fill in the 1st word vs the 2nd word in
cell 1...also some have a middle initial that I do not want to be
included in either but some do not so I need it to recognize the
difference.
--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile:
http://www.excelforum.com/member.php...o&userid=30167
View this thread:
http://www.excelforum.com/showthread...hreadid=498521