CONCAT Excel Formula


Home >> How to Use Excel Tutorial >> Excel Formulas List >> CONCAT Excel Formula



In this Compute Expert tutorial, you will learn the formula of CONCAT in excel. CONCAT excel formula can be used starting from Microsoft Excel version 2019 and is useful to combine more than one data into a text.


Why do We Need to Learn About CONCAT in Excel?


In the use of a spreadsheet, there are many of our data that are spread in each cell in it. Sometimes we need to do a combination on all the data inside a cell range in the spreadsheet and this might be a little bit hard to do by using a manual approach or using the writing of CONCATENATE formula because there are a lot of cells in the range which data needs to be combined to one text. When we write CONCATENATE, we cannot directly input a cell range in it and can only input the cell coordinates one by one.

As an example of that need, imagine if we want to combine each text data in a cell range to make a certain sentence. This might be needed when we create a document template in a spreadsheet. If there are much data on the cells that we need to combine in a particular cell range or there are some document templates that need to be made using the combination process, then it will be troublesome for us if we don’t do it automatically.

To help us in doing a data combination process on many cells in a particular range, then we can use the CONCAT excel formula. CONCAT in excel will help you to combine more than one data in a cell range to the form of a text. It is very useful to be understood and used if you need that kind of combination process in the spreadsheet to create a document or process data related to text.


What is the CONCAT Excel Formula?


CONCAT excel formula is a formula with the usage objective to combine more than one data in a cell range into one text. CONCAT in excel is an update from CONCATENATE function to make its usefulness better and it can only be used in the version 2019 above of this software. If you remember, CONCATENATE has a function which is similar to CONCAT excel formula but if you input a cell range in it, then CONCATENATE will produce an error result. CONCAT in excel solves the problem so you can use a cell range as an input to combine data in it.

Generally, this formula’s input can be explained as follows:


=CONCAT(text1, …)


Note:
text1, … = all the data to be unified to a text


How to Use CONCAT in Excel?


The following part will explain how to use the CONCAT excel formula. CONCAT in excel is pretty easy to use because it only needs the data inputs that you want to unify to a text.


Using CONCAT Excel Formula

  1. Type equal sign ( = ) in the cell where you want to put the process result

    CONCAT Excel Formula - Screenshot of Step 1

  2. Type CONCAT (can be with large and small letters) and open bracket sign after =

    CONCAT Excel Formula - Screenshot of Step 2

  3. Type the data or cell coordinates where you put the things to be combined or drag cursor on the cell range where the data are after open bracket sign with comma sign ( , ) between the data or coordinates or cell ranges that you want to combine (if there are more than one)

    CONCAT Excel Formula - Screenshot of Step 3

  4. Type close bracket sign after all inputs that you want to combine has been inputted

    CONCAT Excel Formula - Screenshot of Step 4

  5. Press Enter
  6. The process is done!

    CONCAT Excel Formula - Screenshot of Step 6



Exercise


After you have learned in detail the step by step of how to use CONCAT in excel, now is the time for you to practice your understanding by doing the exercise below!

Download the exercise file and do all the instructions. Download the answer key file to check your answers or if you are confused and need a clue on how to do the instructions!

Link for the exercise file:
Download here

Questions

  1. Unify all the numbers in the A and B columns!
  2. Unify all the numbers in the fourth, fifth, and ninth rows!
  3. Unify all the numbers from A3 to B5, D4, and C9 to E11!

Link for the answer key file:
Download here


Additional Notes

  • Whatever kind of data that you combine, the final result of the CONCAT excel formula is text
  • In a cell range, this formula will combine the data with the order from the most top-left to the right before down to the most bottom right
  • If you use dates as the inputs to be combined, then CONCAT in excel will use serial numbers of the dates in the combination result
  • If you need spaces in the result, then don’t forget to add them yourself if the data that you combine have no spaces in them (by adding “ “ between your inputs in this formula)




Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on


CONTACT US PRIVACY POLICY TERMS AND CONDITION AFFILIATE DISCLOSURE @Compute Expert