How to Split Text in Google Sheets (3 Easy Methods) (Khmer)

Hello everyone! Today I show you 3 easy methods to split text into separate columns in Google Sheets step by step with video tutorial in Khmer language.

Whether you want to split first name and last name, separate email username from domain, or split product code, these 3 methods will make your work super fast!

Method 1: Split Text to Columns Tool (No Formula)

This is easiest built-in tool in Google Sheets when you don't want to write any formula.

Step by Step:

1. Select column containing text you want to split (e.g. A2:A10).
2. Click Data menu on top bar.
3. Select Split text to columns.
4. A small floating box appears at bottom right (Separator):
   • Choose Detect automatically, Space, Comma, Semicolon, or Custom (e.g. - or /).
5. Google Sheets splits text into adjacent columns instantly!

Method 2: Use SPLIT() Formula (Dynamic Formula)

If you want formula that updates automatically when text changes, use SPLIT() function.

Formula Syntax:

=SPLIT(text, delimiter)

Examples:

• Split by Space (First Name & Last Name):

  =SPLIT(A2, " ")
  

  Sophea Chan ➔ Column B: Sophea, Column C: Chan

• Split by Comma:

  =SPLIT(A2, ",")
  

  Apple, Banana, Orange ➔ Splits into 3 separate cells.

• Split by Hyphen (-):

  =SPLIT(A2, "-")
  

  KH-PHN-2026 ➔ KH | PHN | 2026

Method 3: Use REGEXEXTRACT() Formula (Advanced Pattern)

When text has no clear delimiter (like extracting numbers from text or splitting email address), use REGEXEXTRACT().

Examples:

• Extract Numbers Only from Text:

  =REGEXEXTRACT(A2, "\d+")
  

  Item #4500 USD ➔ 4500

• Extract Text Letters Only:

  =REGEXEXTRACT(A2, "[A-Za-z]+")
  

  Item #4500 USD ➔ Item

• Split Email Username & Domain:

  =REGEXEXTRACT(A2, "^([^@]+)@(.+)$")
  

  info@rean.me ➔ Column B: info, Column C: rean.me

📹 Watch Khmer Video Tutorial

Watch video step by step below to see 3 methods to split text in Google Sheets:

💡 Quick Tip:

• Caution! Overwriting Cells: When splitting text, make sure columns on the right are empty! If adjacent cells have existing data, Google Sheets will overwrite them!
• Split Whole Column at Once: Combine ARRAYFORMULA with SPLIT so you don't need to copy formula down manually: =ARRAYFORMULA(SPLIT(A2:A100, " ")).
• Remove Double Spaces First: If text has uneven extra spaces, wrap with TRIM: =SPLIT(TRIM(A2), " ").

📚 Related Resources

• How to Split Phone Number with Formula in Excel
• How to Split Decimal Number into Two Parts in Excel
• IF vs Equal vs EXACT Function in Excel
• Top 15 Basic Excel Formulas Every Beginner Should Know