Here's one method. In this example the column with names is Column A.
1) In B1, enter:
=FIND(" ",A1,1)
2) In C1, enter:
=IF(ISERR(FIND(" ",A1,B1+1)),0,FIND(" ",A1,B1+1))
3) In D1, enter:
=IF(ISERR(FIND(" ",A1,C1+1)),0,FIND(" ",A1,C1+1))
4) In E1, enter:
=IF(ISERR(FIND(" ",A1,D1+1)),0,FIND(" ",A1,D1+1))
5) In F1, enter:
=MAX(B1:E1)
6) In G1, enter:
=MID(A1,F1+1,LEN(A1))
7) Copy the formulas from B1:G1 down for as many rows as required.
8) To convert the formulas to values:
a) Highlight the formulas and copy them.
b) Paste the formulas to the same location by using the menu: Edit - Paste Special - Values.
I hope this helps. Please advise as to how it fits.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.