I want "JOIN(range, delimiter)" function
To concatenate multiple cells, I can use CONCATENATE() function or simply join by "&". But as a range, there seems to be no handy function.
I want a "JOIN()" function.
ie, for joining from A1 cell to AX1 cell with a delimiter ",", =JOIN(A1:AX1, ",")
You can do this with the TEXTJOIN function, which was added to O365 Excel several years ago.
Thank you so much for you answer. Unfortunately, I'm still using Excel 2010. So I made user function which is similar to TEXTJOIN() and registered it as add-in.
Kenneth Barber commented
These are already available as TEXTJOIN in Office 365. If you don't have Office 365, you can use Formula Pack.