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: -The ampersand (&) calculation operator lets us join text items without using a function. For example, =A1 & B1 will return the same value as =CONCATENATE(A1, B1). In many cases, using the ampersand operator is quicker and simpler than using CONCATENATE to create strings.