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

Options
sweta22
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?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!