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?

Thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!