It is used to join two or more text strings into one string. This function has replaced the CONCATENATE function.
The syntax of the function is the following:
CONCAT(text1, [text2], …)
text1, text2, … : You can have up to 255 items, up to a total of 8,192 characters. The items can be a text value, number, or cell reference.
Click on the button to practice using this function, with the help of our Online Assessment Tool:
Here are two examples of how to use the CONCAT function:
Note: in the videos the CONCATENATE function is used. The syntax of CONCAT and CONCATENATE is the same. Only the name of the function changes.
In the cell A5 insert the appropriate function that joins the text of the cells A1, A2, A3, A4.
In the cell A6 insert the appropriate formula (not a function) that joins the text of the cells A1, A2, A3, A4.
Enter the appropriate formula or function in the cell range E5:E9 to return the Surname and the Name of the client using a space between them.