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

WinaHath

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

Paul Newcome

You would have to use a LEFT function on each individual cell and then add those together.

=LEFT([Column1]@row, 4) + ", " + LEFT([Column2]@row, 4)