Related Topics:
	Spreadsheet Mathematical Functions Data Entry Tips for Functions

CONCATENATE

Description: Joins several text strings into one text string.

Syntax: CONCATENATE (Text1, Text2, ...)

• Text1, Text2, ... are 1 to 30 text items to be joined into a single text item. The text items can be text strings, numbers, or single-cell references.

Remarks:

• The "&" operator can be used instead of CONCATENATE to join text items.

Example:

• CONCATENATE("Total", " ", "Value") = "Total Value". This is equivalent to typing "Total"&" "&"Value".