Last Name, First Name

Smartsheet User 99

Please HELP!!!!!,

I am trying to take someone's full name and turn it into Last Name, First Name.

ex.

ADAMS, JONAH = ADAMS, JONAH

ADAMS, CHRISTOPHE MICHAEL III = ADAMS, CHRISTOPHE

LEE ADAMS, JONAH MICHAEL III = LEE ADAMS, JONAH

I was able to figure out how to pull everything left of the comma, but can't figure out the first name part. I got close but kept running into an issue due to names having multiple spaces or no middle name

Paul H

This seems to work, but I still think it could be simplified

Last Name =LEFT([Full Name]@row, FIND(",", [Full Name]@row))

Last Name Removed = =SUBSTITUTE(RIGHT([Full Name]@row, LEN([Full Name]@row) - FIND(",", [Full Name]@row) - 1), " ", "!") + "!"

Extra Names Removed = =LEFT([Last Name Removed]@row, FIND("!", [Last Name Removed]@row) - 1)

To do it all in a single formula

Fully Nested = =LEFT([Full Name]@row, FIND(",", [Full Name]@row)) + " " + LEFT(SUBSTITUTE(RIGHT([Full Name]@row, LEN([Full Name]@row) - FIND(",", [Full Name]@row) - 1), " ", "!") + "!", FIND("!", SUBSTITUTE(RIGHT([Full Name]@row, LEN([Full Name]@row) - FIND(",", [Full Name]@row) - 1), " ", "!") + "!") - 1)

Paul H

This seems to work, but I still think it could be simplified

Last Name =LEFT([Full Name]@row, FIND(",", [Full Name]@row))

Last Name Removed = =SUBSTITUTE(RIGHT([Full Name]@row, LEN([Full Name]@row) - FIND(",", [Full Name]@row) - 1), " ", "!") + "!"

Extra Names Removed = =LEFT([Last Name Removed]@row, FIND("!", [Last Name Removed]@row) - 1)

To do it all in a single formula

Fully Nested = =LEFT([Full Name]@row, FIND(",", [Full Name]@row)) + " " + LEFT(SUBSTITUTE(RIGHT([Full Name]@row, LEN([Full Name]@row) - FIND(",", [Full Name]@row) - 1), " ", "!") + "!", FIND("!", SUBSTITUTE(RIGHT([Full Name]@row, LEN([Full Name]@row) - FIND(",", [Full Name]@row) - 1), " ", "!") + "!") - 1)

Smartsheet User 99

OMG, OMG, OMG!!! it works!!!!!!! Thank you so much!!!!!!!!!!!!!!!!!!!!!!!