Substitute / or
=SUBSTITUTE([CASE 1]@row, ",", CHAR(10))
Sometimes in the Case 1 cell, staff will enter ex 1, 2 or 1  2.
How would I add a or to substitute either of the scenarios. Thanks
Best Answer

Hi @Mary Kam here's a formula that will substitute the "," or the "" and separate the integers, it will also separate the integers if they separate them with a space (so if they put "13 14" it will show two distinct values just like for the others ("13" and "14").
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE([Case 1]@row, "", CHAR(10)), ",", CHAR(10)), " ", CHAR(10))
Answers

Hi @Mary Kam
I hope you're well and safe!
How would you like it to show? Can you add an example?
Be safe, and have a fantastic week!
Best,
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com  E:andree@workbold.com  P: +46 (0)  72  510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Hi Mary. It looks like you're using a multiselect dropdown column. Instead of writing a formula to correct how people are entering things in this column, why not turn on the "Restrict to drop down choices" option for the column? Down the road someone's going to think of a new way to break your column and you'll have to append your formula to fix that new problem. If you restrict the column to just the choices in the drop down then you don't have to account for how people break your sheet repeatedly.

=SUBSTITUTE([CASE 1]@row, ",", CHAR(10))
I really want a formula that can separate the numbers if they put a , or 
Currently when they put a  the end result is ex: 1112 so the next formula will count this item as 1 when it really is 2 items.
Restricting the columns did not work, but thanks for the suggestion.

Hi @Mary Kam here's a formula that will substitute the "," or the "" and separate the integers, it will also separate the integers if they separate them with a space (so if they put "13 14" it will show two distinct values just like for the others ("13" and "14").
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE([Case 1]@row, "", CHAR(10)), ",", CHAR(10)), " ", CHAR(10))

Thank you so much., it work perfectly.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.7K Get Help
 63 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!