I have a list with a column [Employee Name].
[Employee Name] can have following possibilities:
- Aaron Hawkins
- Abdou Aziz Tebda
- Abdoul Kader Rasac Tiendrebegog
On all 3 cases i want to extract firstname, lastname and middlename and put it as lastname middlename firstname
So after change Above example should show up as:
- Hawkins Aaron
- Tebda Aziz Abdou
- Tiendrebegog Kader Rasac Abdoul
I was able to extract firstname using FIND and Left Funcation
=Left([Employee Name],FIND(" ",[Employee Name]))
=Left(Aaron Hawkins,6) =Aaron
Now how do i extract lastname and middlename so that i can concatenate new values together to get desired result.