This is the simple solution:
Column 1 = Full Name
Column 2 = LEFT(Column1,FIND(" ",Column1,1))
Column 3 = =RIGHT(Column1,LEN(Column1)-LEN(Column2))
Basically the formula for col 2 says take anything in column 1 until you hit
the first space and then for col 3 take col 1 and remove a certain number of
characters from the left side equal to the legnth of col 2.
You can run into problems if you have multiple spaces, like someone has a
midlle initial, but I hope it helps.
"jermsalerms" wrote:
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