CONCAT()
Joins text from multiple cells or strings together, with no delimiter.
CONCAT(text1, [text2], ...)CONCAT joins everything you give it end-to-end into one string. It replaces the older CONCATENATE function and, unlike CONCATENATE, accepts whole ranges — CONCAT(A1:A5) joins all five cells without listing each one.
It has no built-in delimiter — to join with a comma, space, or other separator between items, use TEXTJOIN instead.
Arguments
- text1
- The first text value, cell, or range to join.
- text2, ...optional
- Additional text values, cells, or ranges to join.
Examples
=CONCAT(A2, " ", B2)→John Smith
Joins a first and last name with a space in between.