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
Check out the Formula Handbook template!