FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -You can combine data from multiple cells into a single cell using the Ampersand symbol (&) or the CONCAT function.

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

Detailed explanation-3: -Select a cell where you want to enter the formula. Type =CONCATENATE( in that cell or in the formula bar. Press and hold Ctrl and click on each cell you want to concatenate. Release the Ctrl button, type the closing parenthesis, and press Enter.

Detailed explanation-4: -Concatenating means obtaining a new string that contains both of the original strings. In Python, there are a few ways to concatenate or combine strings. The new string that is created is referred to as a string object. In order to merge two strings into a single object, you may use the + operator.

Detailed explanation-5: -strcat()-Concatenate Strings The strcat() function concatenates string2 to string1 and ends the resulting string with the null character. The strcat() function operates on null-ended strings. The string arguments to the function should contain a null character () that marks the end of the string.