Home » Excel-Built-In-Functions » Excel-Concatenate-Function

The Excel CONCATENATE function joins together up to 30 supplied text strings.

The format of the function is:

where the arguments, text1, text2, etc, can be text strings, numbers or single cell references.

Example

The example below shows the function being used to 'CONCATENATE' the text strings in columns A & B of the example spreadsheet.

Note that, in the example above, text blocks have been added to separate the different fields. For example, in cell D2, the text block ", Age " has been used to separate the name and age.

Also note that in cell D3, the DOB is shown as the number 26815. This is because dates (and times) in Excel are represented as numbers. It is only the formatting of cells that makes dates appear in the date format. The number 26815 is the numeric value associated with the date 31st May 1973 and so this is the value that the function retrieves from cell C3.

In cell D4, the date of birth is displayed in a date format. This has been done with the use of the TEXT function, which is used to translate the number 26815 into a text string in the date format "dd/mm/yy".

The spreadsheet below shows the results of the three CONCATENATE functions in cells D2 - D4.