The CONCAT function

The CONCAT function is a text function which allows you to join together multiple cell values or strings of text into one output.

This is the format of the CONCAT function:

=CONCAT(Value 1, Value 2, Value 3, etc…)


Here is an example of the CONCAT function:

=CONCAT(“Hello”, “ and”, “ welcome”, “ to”, “ Excellency!”) = “Hello and welcome to Excellency!”
CONCAT joining multiple strings of text to one another *NOTE THAT THE CELLS CONTAIN SPACES IN THEM*

CONCAT joining multiple strings of text to one another *NOTE THAT THE CELLS CONTAIN SPACES IN THEM*

It is a function which finds its value in combining the results of multiple other formulas. This can be something as simple as linking together the first and last names of a client, to creating a unique identifier from multiple strings that you can use in a database.

An example of a functional implementation of this function would be where you want to link all purchases to their associated customer profiles. At the time of the transaction you aren’t necessarily linking the transactions, and as a result you need to compare the transaction data to the user data to make these connections. You decide that taking the first name, last name, and postal code from each transaction to create the identifier for each client.

John | Smith | K8J3N0
=CONCAT(First Name Column, Last Name Column, Postal Code Column)  = JohnSmithK8J3N0
TextMatthew Di MinnoComment