Which Excel function is used to concatenate (join) text from multiple cells into one cell?

a) JOIN

b) MERGE

c) CONCATENATE

d) COMBINE

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.