Ways to separate names and phone numbers using Excel functions

ways to separate names and phone numbers using Excel functions

Example: As shown in the following illustration, the contents of column A are required to be split into columns B and C.

Analysis: Chinese characters are double-byte, while letters and numbers are single-byte. In Excel functions, a class of functions with B, such as the LEFTB,RIGHTB,MIDB,SEARCHB function, can differentiate between single and double bytes, so we can use a function with B to solve this problem.

B2 formula:

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

C2 formula

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

Formula Description: SEARCHB is a function to find a particular character position in a string, and it can distinguish between single and double bytes, and it is possible to use wildcard characters for finding and distinguishing. In a formula is a character that represents any single byte, and is a wildcard. Not really looking for a question mark.

The MidB is loaded by byte number. A Chinese character is counted as two bytes, and letters and numbers are counted separately.