CONCATENATE Function in Excel: Syntax, Examples and Free Practice
CONCATENATE is an Excel Text function. Joins several pieces of text into one.
CONCATENATE syntax
=CONCATENATE(text1, [text2], ...)
Arguments
text1: The first piece of texttext2: An additional piece of text (optional)
When to use CONCATENATE
CONCATENATE is used to clean up and reshape text data pulled from other systems before reporting on it.
Practice CONCATENATE online, free
Open the live Excel-style spreadsheet and try CONCATENATE yourself. No Excel install or sign-up needed to start.
Practice CONCATENATE now →More Text functions
Frequently asked questions
What does the CONCATENATE function do in Excel?
Joins several pieces of text into one.
What is the syntax of CONCATENATE in Excel?
The syntax is =CONCATENATE(text1, [text2], ...). text1: The first piece of text; text2: An additional piece of text (optional).
Where can I practice CONCATENATE online for free?
Open the free live spreadsheet on Cellgrids and try CONCATENATE 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