Parsing string data


I have the following data in one column: 01.11101.1002

I would like to parse this into 3 columns:

Column1 = 01

Column2 - 11101

Column3 = 1002

Have tried different ways to parse this out using the Find and left, right function and no luck.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!