Need to add a space every few characters
I am using a form that is turning individual amounts into a long string of numbers.
For instance, information from multiple lines on a separate smartsheet are being entered into a form like this:
But the column created is now showing 275027503500
How do I make a formula to add in a space every four digits? I want it to look like 2750 2750 3500
I've tried changing the form from multiple to single line, but always get the same result.
Help Article Resources
Check out the Formula Handbook template!