Yongle
Well-known Member
- Joined
- Mar 11, 2015
- Messages
- 6,977
- Office Version
- 365
- Platform
- Windows
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
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