How to convert Full name to Last name, First and middle Name(s)?
I have a column with Full names (some with extended middle names) and want to create a column for Last Name, First and Middle name(s).
For example, convert Column A "Angela Marie Walters Smith" to value in Column B of "Smith, Angela Marie Walters"
What formula will return the value I'm looking for?
Help Article Resources
Check out the Formula Handbook template!