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

sweta22

sweta22 ✭✭✭✭

06/13/23 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?

1 ·

Answers

Paul Newcome ✭✭✭✭✭✭

06/13/23

Take a look through the comments here:
https://community.smartsheet.com/discussion/106300/extract-function-select-data-between-defined-tags

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Date Formula Issues, Metric sheet
I am very new to smartsheet. What formula would I use to count how many times the year 2021 appears in the blue (parent) rows? I also would like to make a formula for a metric sheet that automatically updates as I add and delete years from my main sheet. What formula would I use for that part as well? I've tried a few…
Formula to match data from one sheet to another, then calculate the total if a different column true
STUCK in Formula H_ll! lol I'm terrible at formulas and trying to learn! I need your help PLEASE! I have a Master sheet where everyone places orders, it contains the an account number to be charged to and total for each order as well as the status of each order, in a separate sheet I have all of the account numbers. In the…
Next Task on a dashboard
I am trying to create the above to appear in a dashboard. I have been able to pull in everything (Except the data bars as it seems that is not part of the conditional formatting) but I am struggling to figure out how do I pull in the next step. It should be the either the task that is in progress or some of the team wants…