MERGECELLS

Returns the contents from entire ranges and combines them to return a single string.

range1
range2

* The equivalent VBA function is MERGECELLS

	A
1	for example first name and last name in 2 columns