CONCAT Function in Excel: Syntax, Examples and Free Practice
CONCAT is an Excel Text function. The modern version of CONCATENATE, also works across ranges.
CONCAT syntax
=CONCAT(text1, [text2], ...)
Arguments
text1: The first piece of texttext2: An additional piece of text (optional)
When to use CONCAT
CONCAT is used to clean up and reshape text data pulled from other systems before reporting on it.
Practice CONCAT online, free
Open the live Excel-style spreadsheet and try CONCAT yourself. No Excel install or sign-up needed to start.
Practice CONCAT now →Watch: CONCAT in Excel
More Text functions
Frequently asked questions
What does the CONCAT function do in Excel?
The modern version of CONCATENATE, also works across ranges.
What is the syntax of CONCAT in Excel?
The syntax is =CONCAT(text1, [text2], ...). text1: The first piece of text; text2: An additional piece of text (optional).
Where can I practice CONCAT online for free?
Open the free live spreadsheet on Cellgrids and try CONCAT yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Text functions · Excel case studies · Excel tutorials · Excel shortcuts