FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -The CONCATENATE function in Excel is used to join different pieces of text together or combine values from several cells into one cell. The syntax of Excel CONCATENATE is as follows: CONCATENATE(text1, [text2], …) Where text is a text string, cell reference or formula-driven value.

Detailed explanation-2: -The concat() function concatenates the string arguments to the calling string and returns a new string. Changes to the original string or the returned string don’t affect the other. If the arguments are not of the type string, they are converted to string values before concatenating.

Detailed explanation-3: -Concatenation operators join multiple strings into a single string. There are two concatenation operators, + and & . Both carry out the basic concatenation operation, as the following example shows.