Numbers separate by commas read as thousands
I have ONE cell with various numbers/text that users get to input via a form. The input varies from all numbers separated by commas or can have some text as well.
If it is just numbers separated by commas and there are no spaces in between those numbers and commas then cell is read as number. I need some sort of a way / helper column to separate them out into one string that is comma separated and also has spaces not to be mistaken to thousands.
Here is a sample data:
Column Name: Ad ID(s)
row 1: 705,4,7892
row 2: 5
row 3: P35622, 722
As you can see the entries varies significantly from row to row.
How do I consistency "read" them as number/text, number/text, number/text
I tried using this formula =SUBSTITUTE([AD ID(s)]@row, ",", CHAR(10)) and while the output looks correct in Smartsheet, if I try to copy from this multiple picklist cell, pasting to my code gives me this "text", e.g.:
Which does not save any time for the users that need these ad ids grabbed and placed in their codes without any further manipulation. Any thoughts how this can be handled?
P.S. It seems like you still have not fixed your tagging, lol:
Help Article Resources
Check out the Formula Handbook template!