Hi

Here is a basic function. Copy it into a module in the VB editor (ALT&F11).

Function BigConcat(data)
Dim c As Variant, str As String
For Each c In data
str = str & c.Value
Next
BigConcat = str
End Function

Remember though excel only displays a limited number of characters, 256 I
think.


Regards
Peter


"mhei" wrote:

help me please.

How can I merge data from range a to z and the result will
be on column ab without typing =a1&b1&..... is there a
better way doing it?


Thanks