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 November 20, 2018 Views 6,547 Applies to:
Answer

Hi

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.)

Steps:

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
        Else
            TEXTJOIN = TEXTJOIN & textn(i) & delimiter
        End If
    Next
    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)

Regards

Murray

Regards

Murray

31 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.