Is calc can merge cell more than one by one

[frendli]

can calc merge cell not one by one
ex :
im block a1 : c1 than i use ctrl botton than block a4 : c4 , but the merge doesnt show. can anybody help me

[JohnSUN]

May be, you satisfied with this custom function:

REM Concatenate all data from "arrData" with seperator "delimiter"
Function BigConcatenate(arrData, Optional delimiter$) As String
Dim i&, j&
Dim ch$
Dim ersArr() As String
	If IsMissing(delimiter) Then
		ch = ""
	Else
		ch = delimiter
	EndIf
	If IsArray(arrData) Then
		BigConcatenate = ""
		Redim ersArr(LBound(arrData,2) To UBound(arrData,2)) As String
		For i = LBound(arrData,1) To UBound(arrData,1)
			For j = LBound(arrData,2) To UBound(arrData,2)
				If IsEmpty(arrData(i,j)) Then
					ersArr(j)=""
				ElseIf VarType(arrData(i,j))=8 Then ' String
					ersArr(j)=arrData(i,j)
				Else
					ersArr(j)=Trim(Str(arrData(i,j)))
				EndIf
			Next j
			BigConcatenate = BigConcatenate + Join(ersArr, ch)
		Next i
	Else ' First param is not array
		If VarType(arrData)=8 Then ' String
			BigConcatenate = arrData
		Else
			BigConcatenate = Trim(Str(arrData))
		EndIf
	EndIf
End Function

Examles of call:

=BIGCONCATENATE(A1:D2;"; ")
=BIGCONCATENATE(B1)
=BIGCONCATENATE(A5:C5)

Tutorial: How to install a code snippet

File of small example - BigConcatenate.ods

[frendli]

can i know hot to use that…
is that macro…