Navigation:  Formula Reference > Spreadsheet Formula Functions >

CONCATENATE

Previous pageReturn to chapter overviewNext page

 

This function combines multiple text strings or numbers into one text string.

Syntax

CONCATENATE(text1,text2,...)

Arguments

The arguments can be strings, formulas that return a string, or references to cells containing a string. Up to 255 arguments may be included.

Data Types

Accepts string data for both arguments. Returns string data.

Examples

CONCATENATE(B4,D5)

CONCATENATE(R4C2,R5C4)

CONCATENATE(""Gold "", ""Medal"") gives the result Gold Medal

 

See Also

CHAR

EXACT