MOREFUNC

[lehigh46]

Hi All:

For some reason Morfunc is not working.
I tried re-installing it, but after that Excel does not recognize it
anywhere.
I spcificly need it for MCOCAT

I am using XP Pro & Excell Office 2007

Thanks for any help that anyone can give me.

Tom

 

[Bob Phillips]

You can write your own UDF

Function Concat(Delim As String, ParamArray rng())
Dim i As Long
Dim tmp As String
Dim cell As Range

For i = LBound(rng) To UBound(rng)

For Each cell In rng(i)

tmp = tmp & cell.Value & Delim
Next cell
Next i

Concat = Left(tmp, Len(tmp) - 1)
End Function