CONCAT Function

Freebeginner 15 min4 tasks0/54 pts

CONCAT joins text from several cells or whole ranges into one string. It replaces the old CONCATENATE. You can also join with &, which works the same way.

Syntax

CONCAT(text1, [text2], …)

Example: =CONCAT(A2," ",B2) joins first and last name with a space. =CONCAT(A2:B2) joins a range with no gaps.

Common mistakes

Forgetting to add a space, so you get "AnaLopez".
Joining a number and expecting it to keep its formatting.

SEARCH Function TEXTJOIN Function