Excel FunctionsLesson 76Free preview

CONCAT

This lesson is part of Excel · All levels

Summary

CONCAT combines several text, numbers, or cell references into a new string. The modern version of CONCAT accepts ranges at once, as opposed to the old CONCATENATE which only per arguments. These combinations of text are useful in creating IDs, full names, or addresses from several separate columns.

Key points

Syntax: CONCAT(text1, text2, ...)
Receives a direct cell range such as CONCAT(A2:A4)
The result is text, although the source is a number
Optional separators such as spaces are written explicitly with " "

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.