It is used to join two or more text strings into one string. This function has been replaced by the CONCAT function. Even though it is still available you should avoid using it because it may not be available in future versions of Excel.
The syntax of the function is the following:
CONCATENATE(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 CONCATENATE function:
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.