How does Excel segment mobile phone number display?

When we enter a long string of numbers in Excel that are generally not segmented, what if you want to enter a segmented cell phone number in an Excel table? The following is an action tutorial.

Example: the cell phone number in column B, as shown in the figure below, requires that the format be shown as * * * * * * * * * *

Office tips Excel How to segment mobile phone number display

Select column B, CTRL + 1 to open the Cell formatting window-number-custom, and enter the code in the text box on the right;

000 0000 0000

Note: 0 is a single placeholder in a custom format, and a 0 digit.

The effect is set as shown in the following illustration.