Can I get a textjoin() add-in for 2013

Can I get a textjoin() add-in  for 2013. I purchased my PC last fall and it is running excel 2013 and I really do not want to spend more money for just one application.

Question Info

Last updated February 16, 2020 Views 10,486 Applies to:


You could create one if you don't mind a bit of dabbling with VBA. 

(Waring: I'm not familiar with textjoin() but wrote this code based on the description. Not extensively tested.)


1. Open a blank workbook

2. Press ALT+F11 to open the VBA editor

3. In the Project window on the left, right-click on the workbook name and choose Insert ->Module

4. Paste this code in the resultant window

Option Explicit
Function TEXTJOIN(delimiter As String, ignore_empty As String, ParamArray textn() As Variant) As String
    Dim i As Long
    For i = LBound(textn) To UBound(textn) - 1
        If Len(textn(i)) = 0 Then
            If Not ignore_empty = True Then
                TEXTJOIN = TEXTJOIN & textn(i) & delimiter
            End If
            TEXTJOIN = TEXTJOIN & textn(i) & delimiter
        End If
    TEXTJOIN = TEXTJOIN & textn(UBound(textn))
End Function

5. Save the workbook as an add-in type (.xlam)

6. Load the add-in into Excel (File ->Options ->Addins)

Usage is the same as the real textjoin function except that text1 is also optional.

i.e. TEXTJOIN(delimiter, ignore_empty, text1, text2, ...., etc)





35 people were helped by this reply


Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.