How to add symbols in batches in excel

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!