Skip to main content

CONCATENATE

The CONCATENATE function joins several text strings into one text string.

Syntax​

=CONCATENATE(text1, [text2], ...)

Parameters​

  • text1: First text string to join
  • text2, ...: Additional text strings to join (optional)

Examples​

=CONCATENATE("Hello", " ", "World") // Returns "Hello World"
=CONCATENATE("The ", "total ", "is ", 100) // Returns "The total is 100"