Text to columns in Smartsheet


I am trying to separate text to columns (separate email address and add two separate columns with First Name and Last Name information.

I want to add an additional column to display First and Last Name in addition to the email column. As an example, see below:


Additional Column 1: First Name

Additional Column 2: Last Name

In Excel I would simply use the Text to Columns functionality.

Is there a formula to do so in Smartsheet and if so, can someone share it with me?

Thank you!



  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭

    Hi Alex,

    You have to parse out the name. If all of your emails are the same structure as your example it's easy. If they aren't it could be very challenging.

    For your example: FirstName.LastName@gmail.com

    First name: =LEFT(email@row, FIND(".", Email@row))

    Last name: =MID(FIND(".", Email@row)+1, FIND("@", email@row)-FIND(".", Email@row)+1)

    Substitute your email column mane for my email placeholder.



    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!