Excel Function : CONCATENATE

Download now!

Excel Function : CONCATENATE

Category

Text

Description

Joins several text items into one text item

Microsoft Excel Reference Page

https://support.office.com/en-us/article/CONCATENATE-function-8f8ae884-2ca8-4f7a-b093-75d702bea31d

Syntax and Description of the CONCATENATE Excel Function

The syntax for the CONCATENATE function in Microsoft Excel is: CONCATENATE(string1, [string2], ...) Where string1, string2, ... are the strings to be concatenated.

About CONCATENATE Excel Function

The CONCATENATE function concatenates a list of text strings into a single text string. The list of text strings can be provided as a range of cells, or as a list of text strings separated by a delimiter.