a) JOIN
b) MERGE
c) CONCATENATE
d) COMBINE
Show Answer
c) CONCATENATE
Show Answer
c) CONCATENATE
In Excel, the function used to concatenate or join text from multiple cells into one cell is called CONCATENATE. You can also achieve the same result using the ampersand (&) operator. The CONCATENATE function and the ampersand operator both allow you to combine text from different cells into a single cell.
