FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -The CONCATENATE Function[1] is categorized under Excel Text Functions. The function helps to join two or more strings into one string.

Detailed explanation-2: -Ampersand (&) Was this answer helpful?

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

Detailed explanation-4: -Type the CONCATENATE operator (&) by pressing Shift + 7 (at the top of the keyboard). Type the cell reference for the cell you want to combine or click it.