What is the usage of & in excel?

& is the connector, you can press Shift and 7 at the same time to get it out.

In Excel, when we need to merge the contents of multiple cells into one cell, we can merge them through the "&" symbol. This is the connection between cells. The input format is =cell Cell & cell & cell, use & to connect several to merge them.

Related recommendations: "excel basic tutorial"

If you merge the contents of multiple cells, separate them with commas Just put the text you want to connect through " " in the middle, that is, the required comma.

The "&" symbol is equivalent to the concatenate function, that is, when the cell input format is =A1&B1&C1

, the function formula that can be entered is =CONCATENATE(A1,B1,C1)

The above is the detailed content of What is the usage of & in excel?. For more information, please follow other related articles on the PHP Chinese website!