I’ve looked, and I am not sure I completely understand; I’m new to VBA.
I can’t remember how to create an add-in – which I drop into the program-files so the new function is always available.
I may be explaining this completely stupid, I apologize – I have a =ConcatenateRange function I want to add-in to excel, so when I pull a new workbook up, the same function is there, and I don’t need to ALT+F11 to add it each time.. I know I can create a file and add it – but I am not sure.
Anyone assist me?

Function ConcatenateRange(ByVal cell_range As range, _
Optional ByVal seperator As String) As String

Dim cell As range
Dim newString As String
Dim cellArray As Variant
Dim i As Long, j As Long

cellArray = cell_range.Value

For i = 1 To UBound(cellArray, 1)
For j = 1 To UBound(cellArray, 2)
If Len(cellArray(i, j)) <> 0 Then
newString = newString & (seperator & cellArray(i, j))
End If
Next
Next

If Len(newString) <> 0 Then
newString = Right$(newString, (Len(newString) - Len(seperator)))
End If

ConcatenateRange = newString

End Function