last, first to first last

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))

Tags:

Answers

  • Jason Tarpinian
    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)

    Jason Tarpinian - Sevan Technology

    Smartsheet Aligned Partner

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!