how do I get TEXTJOIN for excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1336220%22%20slang%3D%22en-US%22%3Ehow%20do%20I%20get%20TEXTJOIN%20for%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1336220%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20I%20get%20the%20TEXTJOIN%20function%20for%20Microsoft%20Office%20Professional%20Plus%202016%3F%20When%20I%20go%20to%20formulas%20it%20is%20not%20a%20choice.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1336220%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1336241%22%20slang%3D%22en-US%22%3ERe%3A%20how%20do%20I%20get%20TEXTJOIN%20for%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1336241%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F636136%22%20target%3D%22_blank%22%3E%40tmk2015%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20on%20Office365%20subscription%20or%20on%20Excel%202019.%20It%20will%20never%20be%20on%202016.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1336260%22%20slang%3D%22en-US%22%3ERE%3A%20how%20do%20I%20get%20TEXTJOIN%20for%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1336260%22%20slang%3D%22en-US%22%3EAs%20this%20function%20is%20available%20in%20Office%20365%20only%2C%20MS%20Office%202016%20Package%20does%20not%20have%20this.%20Alternatively%2C%20you%20should%20add%20below%20VBA%20code%20into%20your%20VBA%20module%20and%20then%20use%20%3Djointext(%22Excel%20range%22)%20and%20enter%20i.e.%20%3Djointext(A1%3AA5)%20Function%20jointext(Ref%20As%20Range%2C%20Separator%20As%20String)%20As%20String%20Dim%20Cell%20As%20Range%20Dim%20Result%20As%20String%20For%20Each%20Cell%20In%20Ref%20Result%20%3D%20Result%20%26amp%3B%20Cell.Value%20%26amp%3B%20Separator%20Next%20Cell%20jointext%20%3D%20Left(Result%2C%20Len(Result)%20-%201)%20End%20Function%20Regards%20Kapil%20%3CA%20href%3D%22http%3A%2F%2FWWW.Excelsirji.Com%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EWWW.Excelsirji.Com%3C%2FA%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Can I get the TEXTJOIN function for Microsoft Office Professional Plus 2016? When I go to formulas it is not a choice.

2 Replies

@tmk2015 

That's on Office365 subscription or on Excel 2019. It will never be on 2016.

Highlighted
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