Formula for Name separated by Commas


Is there a formula that can give me all of the text to the left of a comma and all of the text to the right of a comma? I have a list of names and my LEFT FIND formulas aren't working correctly.

For example,

My list has names like this

Adam, Smith

Susan-Anne, Smith

Bob, Wilson

I need a First Name Column and a Last Name column


Best Answer

  • Jason Tarpinian
    Jason Tarpinian ✭✭✭✭✭✭
    Answer ✓

    As long as there's just one comma in each name represented, you can separate them into first/last with these formulas:

    First =LEFT(Name@row, FIND(",", Name@row) - 1)

    Last =RIGHT(Name@row, LEN(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!