Office Excel – CONCAT Function

Microsoft releases new iterations of Microsoft Office suite every three years for desktop and Microsoft Office 365 is the subscription based cloud version of their Office software. Earlier in 2016, Microsoft released the 2016 edition of Office and some updates to Office 365 which added new features in Excel. Some very useful functions like the CONCAT and TEXTJOIN functions are added which make concatenating or joining text very easier with multiple cells or strings in your spreadsheet. These functions are only available in the latest Office 2016 desktop installation and Office 365 subscription. To show these new functions, here is the Excel CONCAT and TEXTJOIN function tutorial. I am breaking them into 2 different tutorials for ease of access.

Through the Office Excel CONCAT function, you can connect two or more text in different cells in your spreadsheet. When you connect two text, they are just joined together with no separation or space between them. Here is the tutorial on how to use Excel CONCAT function:

The format of the Excel CONCAT function is:
CONCAT(text1, text2, … , textN)

Where “text1” is the first string or cell and “textN” is the nth string or cell which you want to concatenate.

  1. In your Excel spreadsheet, see which cells or strings you want to concatenate.
  2. Then select a cell where you want to display the concatenated text.
  3. For example, in this following example spreadsheet, we want to concatenate the text in cells A11 through D11 and we want to display the output in cell F11.
  4. Select the cell F11 and enter the CONCAT function in the formula bar above the spreadsheet:
  5. =CONCAT(A11,B11,C11,D11)

  6. After entering the function, you will see the result in cell F11:
  7. Excel Concat

    Excel Concat

  8. As you can see in the example, the data in cells A11 through D11 is now concatenated in cell F11 and there are no spaces between the text.
  9. You can do this with numbers as well, like in the result shown in cell F12:
  10. Excel Concat

    Excel Concat

  11. If you enter a cell in the function which is empty, the function will not show anything from that cell in the output:
  12. Excel Concat

    Excel Concat

  13. You can also directly add a string in the function, as shown in the following example:
  14. Excel Concat

    Excel Concat

You can view more Office Excel Tutorials in the link too!