Single string from dynamic named range

[Yongle]

Is there a formula (array or otherwise) that can be used to generate a single string from all the values in a single column dynamic named range. I want each value delimited by CHAR(10)
TEXTJOIN would do the trick (Excel 365) but need it to work with earlier versions of Excel

Already have both VBA \ UDF solutions which I am trying to avoid.

Many thanks

 

[Special-K99]

Nope Youve covered all the possibilities.
TEXTJOIN, otherwise VBA / UDF.

 

[Yongle]

Thank you