RELATED IDEAS
Support TEXTJOIN function in Excel as Middleware
Support the TEXTJOIN function in Excel so writing formulas is less work. Make work less work....?
Formula using TEXTJOIN:
=TEXTJOIN(“, “,TRUE,I17:I26)
Formula without TEXTJOIN: =IF(L17=“”,“”,L17)&IF(L18=“”,“”,CONCATENATE(“, “&L18))&IF(L19=“”,“”,CONCATENATE(“, “&L19))&IF(L20=“”,“”,CONCATENATE(“, “&L20))&IF(L21=“”,“”,CONCATENATE(“, “&L21))&IF(L22=“”,“”,CONCATENATE(“, “&L22))&IF(L23=“”,“”,CONCATENATE(“, “&L23))&IF(L24=“”,“”,CONCATENATE(“, “&L24))&IF(L25=“”,“”,CONCATENATE(“, “&L25))
Formula using TEXTJOIN:
=TEXTJOIN(“, “,TRUE,I17:I26)
Formula without TEXTJOIN: =IF(L17=“”,“”,L17)&IF(L18=“”,“”,CONCATENATE(“, “&L18))&IF(L19=“”,“”,CONCATENATE(“, “&L19))&IF(L20=“”,“”,CONCATENATE(“, “&L20))&IF(L21=“”,“”,CONCATENATE(“, “&L21))&IF(L22=“”,“”,CONCATENATE(“, “&L22))&IF(L23=“”,“”,CONCATENATE(“, “&L23))&IF(L24=“”,“”,CONCATENATE(“, “&L24))&IF(L25=“”,“”,CONCATENATE(“, “&L25))
-
ADMIN RESPONSESep 8, 2022We are currently evaluating this for inclusion in our next development cycle. Please share with us how this would improve your experience, and pass this on to other users who might like to vote and comment. Thanks!
