CONCATENATE

What does the CONCATENATE function do?

The function performs the concatenation operation.

Concatenation is combining several text values into one, in other words, joining text fragments. Hence the name of the function – CONCATENATE.

CONCATENATE function syntax

=CONCATENATE(text1, text2, text3...)

The function arguments can be either cell references or manually entered values.

Concatenate dates in Excel

Many know that dates, when processed by text functions, are converted to whole numbers, which interferes with their insertion into text.

The issue is that there are no separate formats for dates in Excel, and they are indeed numbers. Moreover, they can be written in dozens of ways.

To convert a date to text and get the desired formatting, the TEXT function will help. It converts numeric values into various representations in text format – percentages, dates, date-time, or time.

A short date notation in the format xx.xx.xx would look like this:

=TEXT(M4, "dd.MM.yy") & " year"

But in this case, we need to display the full date with the month in the genitive case.

Under this condition, the formula for conversion using the TEXT function looks like this:

=TEXT(M4, "[$-FC19]dd MMMM yyyy") & " year"

This post is also available in RU.