Convert Last, First Name to First Last Name

I have a contact list of Last Name, First Name; i.e. Doe, John. I would like to create a helper column with First Name Last Name; i.e. John Doe. Is there a formula to do that?

Thanks in advance!

Best Answer


  • This works! Thank you much!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!