last, first to first last

Jennifer Seymour

I want to flip a column which will be last, first names and return first last.

So Doe, John becomes John Doe

I can get each piece - but is there any functionality to build the string? Having a first name column and a last name column is not helpful.

Last Name Formula:

=LEFT(NAME31, FIND(",", NAME31) - 1)

First Name Formula:

=RIGHT(NAME34, LEN(NAME34) - FIND(",", NAME34))

Jason Tarpinian

You can concatenate cells in Smartsheet with the + symbol (similar to the & in Excel, if you are familiar how to use that). So all you have to do is add them together with:

=RIGHT(NAME@row, LEN(NAME@row) - FIND(",", NAME@row) - 1) + " " + LEFT(NAME@row, FIND(",", NAME@row) - 1)