Formula help to JOIN results of LEFT formula down a column
I have a column of values, I'd like to use a Join function to combine all the values into a list, but first i'd like each of these values to be trimmed via the left function. Here is an example of the Left function I am using:
=LEFT([ColumnName]1, FIND(CHAR(10), [ColumnName]1))
How do I integrate this into a JOIN operation so that I get my desired result? I understand I could use a helper column to first do the LEFT operation and then run JOIN on that column but I'd prefer to avoid that if possible. I have no issue with a large dense formula. Below is a working formula for a single cell vs a whole column
=JOIN(DISTINCT(LEFT([ColumnName]1, FIND(CHAR(10), [ColumnName]1))), "; ")
Answers

You would need to use the helper column.
Help Article Resources
Categories
Check out the Formula Handbook template!