របៀបបំបែកឈ្មោះពេញ(ខ្មែរ) ជាត្រកូល និងឈ្មោះ ប្រើរូបមន្ត Excel (Video in Khmer)

Hello everyone! Today I show you very easy step-by-step how to split full name into first name and last name in Excel using formulas LEFT, RIGHT, LEN, and FIND. If you have list of staff or student names in one column and want to split them fast, this trick help you very much!

🛠️ Easy Step-by-Step Formula

Suppose your Full Name is in Cell A2 (example: Chan Dara).

Step 1: Find Space Position (FIND Formula)

First, we need to locate where space " " is inside full name cell:

=FIND(" ", A2)

If full name is Chan Dara, space is at character position 5.

Step 2: Extract First Name (LEFT Formula)

To get the first word before space:

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

• LEFT(A2, ...) takes characters from the left side of text.
• - 1 is used to remove space character at the end.
• Result: Chan

Step 3: Extract Last Name (RIGHT + LEN Formula)

To get the last word after space:

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

• LEN(A2) counts total character length of full name.
• LEN(A2) - FIND(" ", A2) calculates remaining characters after space.
• RIGHT(A2, ...) extracts remaining characters from the right side.
• Result: Dara

Example Video Split Name (Khmer Names) in Excel

📚 Related Tutorial: Learn How to use Text (LEFT, RIGHT, MID,...) Functions in Excel? Check out How to Use Text Functions in Excel!

Example Video Split Name (Latin Names) in Excel

📚 Related Tutorial: Want to master Excel keyboard shortcuts? Check out Learn All Excel Keyboard Shortcuts!

💡 Pro Tips

1. Fastest Trick (Flash Fill Ctrl + E):
   • Type first name manually in B2 (Chan).
   • Press Ctrl + E (Excel will auto fill all remaining first names instantly without formula!).
   • Do same for last name in C2 (Dara) and press Ctrl + E.
2. Modern Excel 365 (TEXTSPLIT Formula):
   • If you use modern Excel 365, no need long formula! Just use:

     =TEXTSPLIT(A2, " ")
     

     Excel will split full name into 2 columns automatically!
3. Clean Extra Spaces (TRIM Formula):
   • If your text have double spaces like "Chan Dara", wrap your cell with TRIM(A2) first to avoid formula error!