1. Select the cell where you want to add a symbol, right-click and select the [Format Cells] option;
2. Switch to [Custom Classification];
3. Enter the character type as needed and click [OK].
The symbol # here represents the number of divided values, indicating that the phone number is divided according to the rule of 3 4 4, and the interval symbol is "-".
Let’s take a look at the effect:
Recommended tutorial: excel tutorial
The above is the detailed content of How to add symbols in batches in excel. For more information, please follow other related articles on the PHP Chinese website!