The Merge() function combines one or more ranges of cells. This function is only available for use in Excel.

Syntax:

Qx.Merge(Ranges)

• In Excel with Quintessence addin versions prior to 25.1, use: Merge()

Remarks:

• We recommend using formatted reports to merge cells rather than the Merge() function.

Examples:

The examples provided below are based on fictitious data for illustrative purposes only.

> Example 1: Merge multiple sets of cells

Range of data in Excel (A1:D8):

AAA
BBB	A11	B22
CCC
	1	2
	3	4
	5	6
			C33
	X	Y	Z

Three separate ranges in this range will be merged:

• A1:A3
• C6:B4
• B7:D8

=Qx.Merge("A1:A3,C6:B4,B7:D8")

This function returns TRUE, indicating that the merge was applied. Merged result: