How to Split Phone Number with Formula in Excel (Khmer)

Hello everyone! Today I show you how to split phone numbers into two separate columns in Excel step by step with easy formulas and video guide in Khmer language.

Many times when customer or staff type data, they put two phone numbers inside one cell like this:

• 012998877 011223311 ➔ Split to 012998877 and 011223311
• 010333444 015556655 ➔ Split to 010333444 and 015556655

Here are simple formulas using LEFT, MID, FIND, LEN, and IF to split them easily!

Method 1: Extract First Phone Number (Before Space)

To get first phone number from cell A2:

Use LEFT and FIND formula:

=LEFT(A2, FIND(" ", A2) - 1)

How it work:

• FIND(" ", A2) search position of space character.
• LEFT(..., FIND(...) - 1) cut text from left side up to before space.

Method 2: Extract Second Phone Number (After Space)

To get second phone number from cell A2, you have 2 options:

Option A: Using MID and LEN Formula (Recommended)

=MID(A2, FIND(" ", A2) + 1, LEN(A2))

Option B: Using RIGHT, LEN, and FIND Formula

=RIGHT(A2, LEN(A2) - FIND(" ", A2))

How it work:

• FIND(" ", A2) + 1 find start position of second number right after space.
• MID or RIGHT cut remaining digits after space position.

Method 3: Smart Formula with IF (Prevent #VALUE! Error)

If some cell only have 1 phone number (no space inside), formula above will return #VALUE! error!

To fix this, wrap with IF and ISNUMBER:

For First Phone Number Column:

=IF(ISNUMBER(FIND(" ", A2)), LEFT(A2, FIND(" ", A2) - 1), A2)

For Second Phone Number Column:

=IF(ISNUMBER(FIND(" ", A2)), MID(A2, FIND(" ", A2) + 1, LEN(A2)), "")

📹 Watch Khmer Video Tutorial

Watch video step by step below to see how to split phone number in Excel:

💡 Quick Tip:

• Text to Columns (No Formula): You can also split without formula! Select cell range ➔ go to Data tab ➔ click Text to Columns ➔ select Delimited ➔ check Space box ➔ click Finish!
• Keep Leading Zero (0): Phone numbers in Cambodia start with 0 (e.g. 012...). When splitting, format target cells as Text or format custom code '000000000 so Excel not auto delete leading zero!
• Excel 365 / 2021 New Formula: If you use newest Excel, write =TEXTSPLIT(A2, " ") to split both numbers across columns automatically!

📚 Related Resources

• How to Split Decimal Number into Two Parts in Excel
• How to Use Clean Text Formula in Excel
• How to Convert Number into Khmer Number and Back in Excel
• Top 15 Basic Excel Formulas Every Beginner Should Know