How do I get just the first 4 characters to the left of the text string (2700-insurance)

JOIN(COLLECT([2700 & 5090 Codes]@row:[6000 Codes]@row, [2700 & 5090 Codes]@row:[6000 Codes]@row, @cell <> ""), ", ")

I need to get the first 4 numbers to the Left of the text string from each of the columns and output to another column. there are 9 columns that I will be collecting from.

Thanks for any help



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!