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.
USAGE:
JOIN(<RANGE>, <DELIMITER>)
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.
2 comments
-
longmanne commented
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.
https://support.office.com/en-us/article/TEXTJOIN-function-357b449a-ec91-49d0-80c3-0e8fc845691c
https://www.bernardvukas.com/excel-formula-pack/whats-new-beta/