CONCAT

New Excel function in Excel 2016

The CONCAT function works in the same way as the existing CONCATENATE function. The key difference is that it can be used to reference ranges instead of individual cells.

Syntax

CONCAT(text1, [text2],…)

The text can be text, a cell reference or a range.

All [text] values after the first value are optional.

Comments

Empty cells and ranges are ignored.

Best to use

• To make dynamic report headings or text.
• In constructing SQL statements.

Limitations

The function can reference 254 pieces of text, cells or ranges.

It will return a maximum of 32767 character before showing #VALUE!

Tip

If referring to a range, make sure that the text in each cell ends with a space.

When it is displayed, it will not be bunched together with no spacing.

Examples