Forum Discussion
how do I get TEXTJOIN for excel
Can I get the TEXTJOIN function for Microsoft Office Professional Plus 2016? When I go to formulas it is not a choice.
2 Replies
- As this function is available in Office 365 only, MS Office 2016 Package does not have this. Alternatively, you should add below VBA code into your VBA module and then use =jointext("Excel range") and enter i.e. =jointext(A1:A5) Function jointext(Ref As Range, Separator As String) As String Dim Cell As Range Dim Result As String For Each Cell In Ref Result = Result & Cell.Value & Separator Next Cell jointext = Left(Result, Len(Result) - 1) End Function Regards Kapil WWW.Excelsirji.Com
That's on Office365 subscription or on Excel 2019. It will never be on 2016.
