The CONCATENATE function joins up to 255 text strings into one text string. The joined items can be text, numbers, cell references, or a combination of those items.

CONCATENATE takes 1 required argument and 254 optional arguments:

Syntax: CONCATENATE(text1, [text2], ... )

#1)
Using the CONCATENATE function:
#2)
The arguments for the CONCATENATE function are:
Argument Required? Description
text1 Required The first text item to be concatenated.
text2, ... Optional Additional text items, up to a maximum of 254 additional items. The items must be separated by commas.

Summary

The CONCATENATE function joins up to 255 text strings into one text string. The joined items can be text, numbers, cell references, or a combination of those items.
comments powered by Disqus