{"id":838,"date":"2019-04-19T15:28:51","date_gmt":"2019-04-19T12:28:51","guid":{"rendered":"https:\/\/www.test4u.eu\/excelpedia\/?p=838"},"modified":"2019-04-19T15:29:25","modified_gmt":"2019-04-19T12:29:25","slug":"the-concat-function","status":"publish","type":"post","link":"https:\/\/www.test4u.eu\/excelpedia\/the-concat-function\/","title":{"rendered":"The CONCAT Function"},"content":{"rendered":"\n

It is used to join two or more text strings into one string. This function has replaced the CONCATENATE <\/a><\/strong>function.<\/p>\n\n\n\n

The syntax of the function is the following: <\/p>\n\n\n\n

CONCAT<\/strong>(text1, [text2], …<\/b><\/span><\/em>) <\/p>text1, text2, …<\/strong> : 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.
<\/cite><\/blockquote>\n\n\n\n

<\/div>\n\n\n\n\n
<\/div>\n\n\n\n

Click on the button to practice using this function, with the help of our Online Assessment Tool<\/strong>:<\/p>\n\n\n

Practice<\/a><\/p>\n\n\n\n

<\/div>\n\n\n\n\n

Here are two examples of how to use the CONCAT function:<\/strong><\/p>\n\n\n\n

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.<\/strong><\/p>\n\n\n\n

In the cell A5 insert the appropriate function that joins the text of the cells A1, A2, A3, A4.
\nIn the cell A6 insert the appropriate formula (not a function) that joins the text of the cells A1, A2, A3, A4.<\/p>\n\n\n\n

\n