Home >Topics >excel >How to add symbols in batches in excel

How to add symbols in batches in excel

王林
王林Original
2020-06-11 15:02:3517791browse

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;

How to add symbols in batches in excel

2. Switch to [Custom Classification];

How to add symbols in batches in excel

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 "-".

How to add symbols in batches in excel

Let’s take a look at the effect:

How to add symbols in batches in excel

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn