Formula help to JOIN results of LEFT formula down a column

ritzbitz00

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))), "; ")

Paul Newcome

You would need to use the helper column.