MOREFUNC
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
--
__________________________________
HTH
Bob
"lehigh46" wrote in message
...
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
|