Text to columns in Smartsheet

Alexandra Waltz

Hello,

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:

FirstName.LastName@gmail.com

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!

Alex

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.

Work?

Mark