FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -The CONCATENATE function breaks a text string into separate strings. A delimiter is a data separator. Data can be consolidated from different workbooks in one worksheet.

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

Detailed explanation-3: -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. For string variables, concatenation occurs only at run time.

Detailed explanation-4: -3 ways to Excel Concatenate with Line Break This is done by entering the CHAR( ) function in between each text string/argument. CHAR function returns a character specified by a number from 1 to 255. For example, CHAR(10) returns a line break in windows, CHAR(34) returns a ” (double quote), CHAR(64) returns , etc.