Question

it combines a group of cells into a single cells​

Answer 1

Answer:

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

Answer 2

Answer:

Concatenate is simply a fancy way ot saying “to combine” or “to join together” and there is a special CONCATENATE function in Excel to do this. This function allows you to combine text from different cells into one cell. For example, we have a worksheet containing names and contact information.

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

You can also concatenate text from multiple cells using the ampersand (&) operator. For example, you can enter =B2&" "&A2 to get the same result as =CONCATENATE(B2,” “,A2) .