Hi!,
just wanted to ask, how can i split the full name if the full name includes multiple names and with suffix in google sheets?
example:
Thank you in advance!
just wanted to ask, how can i split the full name if the full name includes multiple names and with suffix in google sheets?
example:
Full Name | First Name | Last Name | Suffix |
Vincent Chavez | Vincent | Chavez | |
Vincent Adrian Lantin Jr | Vincent Adrian | Lantin | Jr |
Andrea Mae Joy Ruallo | Andrea Mae Joy | Ruallo | |
Adrian Martin Nunez Sr. | Adrian Martin | Nunez | Sr. |
Thank you in advance!