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:

2750

2750

3500

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.

Thanks!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!