How would I split text separated by commas into new cells?

sweta22 ✭✭✭✭
edited 06/13/23 in Formulas and Functions

Example, in one cell I have the text "Zach, Max, Prince, Bob, Rick and more"

How do I split that to have each name in each column, all on the same row?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!