Sub test()
x = Nom_Prenom("DE LA VILLARDIERE Jean Edhourd")
MsgBox x(1) & vbCrLf & x(2)
End Sub
Function Nom_Prenom(chaine)
Dim t(1 To 2),tx,i&
tx = Split(chaine, " ")
For i = 0 To UBound(t)
If UCase(tx(i)) = tx(i) Then t(1) = Trim(t(1)) & " " & tx(i) Else Exit For
Next
t(2) = Trim(Replace(chaine, t(1), ""))
Nom_Prenom = t
End Function