Get first name from Last, First |
FIND LEN RIGHT |
Get first name from name |
FIND LEFT |
Get last name from Last, First |
LEFT LEN |
Get last name from name |
FIND LEN RIGHT SUBSTITUTE |
Get middle name from full name |
LEN MID TRIM |
Join first and last name |
CONCATENATE |
Put names into proper case |
PROPER TRIM |