What symbol can be used to concatenate two strings in Excel?

What symbol can be used to connect two strings in Excel?

1. Take the excel2010 version as an example, as shown below, you need to splice the two strings of department and name;

Recommendation: "Excel Tutorial"

2. You can use the symbol "&" to splice, enter the formula =A2&B2 in cell C2, and press the enter key to get the splicing result;

3. In the same way, place the mouse on the lower right corner of cell C2 and pull down to fill in the formula. Then the two strings of the department and name of the table can be spliced.

The above is the detailed content of What symbol can be used to concatenate two strings in Excel?. For more information, please follow other related articles on the PHP Chinese website!