For the first name you can use
=LEFT(A1,FIND(" ",A1)-1)
For the surname, a new user defined function can be used.
(Select Surname from user defined list after pasting the following to a
VBA module)
Function Surname(Cell)
For M = Len(Cell) To 1 Step -1
If Mid(Cell, M, 1) < " " Then
Surname = Mid(Cell, M, 1) & Surname
Else
Exit For
End If
Next M
End Function
--
mrice
Reserach Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile:
http://www.excelforum.com/member.php...o&userid=10931
View this thread:
http://www.excelforum.com/showthread...hreadid=535353