How to Separate Text?

Options

Hello,

I have a list of names and I want to separate them by last and first name. I am not seeing a function to accomplish this in Smartsheet like you would in excel.


=TEXTBEFORE(A2,",") and =TEXTAFTER(A2,",")

Full Name Last Name First Name

Barbosa, Fred Barbosa Fred


Any suggestions?

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!