How to quickly separate names and phone numbers using Excel tables

use Excel forms to quickly separate names and phone numbers the method

Separate name and cell phone number

The common formulas are:

B2 formula:

=LEFTB (A2,searchb ("?", A2)-1)

C2 formula

=MIDB (A2,searchb ("?", A2), 11)

In fact, there is a quicker way than this, and there is no need for any formulas or functions. Just adjust column A to the width of 4 characters, and then execute: Start-fill-justify

The name and phone number after execution have been completely separated, as shown in the following figure

Then you only need to do a little sorting, in the B2 input 1 and then select B2:b3 down copy.

Then filter the 1 duplicate names by column B and filter the blank copy phone number to complete the separation.