The CONCAT function is one of the text functions that allow you join two or more cells together. This is the function to replace the CONCATENATE function, but easier to type. CONCATENATE will be still compatible with earlier versions, but not in Excel 2019.
= CONCAT(Cell 1, Cell 2…), comma is necessary
Cell 1 is required, the first part that you will need to join;
Cell 2 is required, when you need to join cell 1 with this cell;
… (Other cells) is optional, you can join as many as cells.
1. The CONCAT function will need a comma (,) between cells.
2. If TEXT content is included in the function, the quotation marks are necessary, while numbers do not need.
Examples 1: To join Last Name and First Name together
When using the CONCAT function directly links B2 and A2 together, we get the result of "JohnsonAiden".
To format the results better, we can add spaces and comma in the function. To have "Last, First", we can use the following combination:
Example 2: to add 5 spaces in front of the cell content
To have spaces in front of cell contents, you can use CONCAT function by adding spaces with quotation marks, then copy down to other cells.
=CONCAT(" ", B2)
There are 5 spaces in the quotation marks.
1. Using the formula of the ampersand (&) can achieve the same results;
2. In Excel 2016, the CONCATENATE function is replaced with the CONCAT function. The CONCATENATE function is still working in Excel 2016, but it is not available from Excel 2019.