Concatenate range in excel
Concatenate range with your own defined separator Public Function miconcat(ByRef miRange As Range, Optional miDelimiter As String = " ")
Dim d As Range
Dim cc As String Application.Volatile
For Each d In miRange
cc = cc & d & miDelimiter
Next d
miconcat = cc
End Function
Dim d As Range
Dim cc As String Application.Volatile
For Each d In miRange
cc = cc & d & miDelimiter
Next d
miconcat = cc
End Function