FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -The CONCATENATE function joins two or more text strings together into one string. For example, if you have the customer’s first name in Column A and the last name in Column B, you could use “=CONCATENATE(A3, “ ”, B3)” to produce a string containing first name and last name.

Detailed explanation-2: -Concatenation is the process of appending one string to the end of another string. You concatenate strings by using the + operator. For string literals and string constants, concatenation occurs at compile time; no run-time concatenation occurs.

Detailed explanation-3: -Use CONCATENATE, one of the text functions, to join two or more text strings into one string.

Detailed explanation-4: -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-5: -The ampersand symbol is the recommended concatenation operator. It is used to bind a number of string variables together, creating one string from two or more individual strings.