Concat vs TextJoin Function in Excel (Video in Khmer)

Hello everyone! Today I show you how to use CONCAT and TEXTJOIN formula in Excel step by step with simple examples and video speak Khmer.

You ever want to join text from different cell into one cell? Like join First Name and Last Name together? Excel have formula for this, but many people don't know whether to use CONCAT or TEXTJOIN. Both can join text, but TEXTJOIN is more powerful because it can add separator (like space or comma) automatic and skip empty cell!

Let's look at how to use both function below.

1. How to Concat/Concatenate Formula in Excel

CONCAT function is upgraded version of old CONCATENATE formula in Excel. It help you join text from multiple cell or range into single cell. Very simple to use.

Formula Syntax:

=CONCAT(text1, [text2], ...)

Example:

If cell A2 has "Hello" and cell B2 has "World":

• =CONCAT(A2, B2) ➔ HelloWorld
• If you want space between word, you must add space manually: =CONCAT(A2, " ", B2) ➔ Hello World

Watch video below to see step by step in Khmer:

2. How to TextJoin Formula in Excel

TEXTJOIN function is super smart formula! When you have many cell to combine, TEXTJOIN allow you to set delimiter first (like , or - or space " "), and then you can tell Excel to ignore empty cell (TRUE) or keep empty cell (FALSE).

Formula Syntax:

=TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)

Example:

If cell A2:A5 contain names ["John", "", "Sophea", "Dara"]:

• =TEXTJOIN(", ", TRUE, A2:A5) ➔ John, Sophea, Dara (It skip blank cell automatic!)

Watch video below for full guide in Khmer:

💡 Quick Tip: If you work with large list of data or combining range of cells with delimiter like comma or dash, always use TEXTJOIN instead of CONCAT. CONCAT cannot add delimiter automatically for a range, but TEXTJOIN do it in one simple step! Note: TEXTJOIN is available in Excel 2019, Excel 365, and Excel for Web.

📚 Useful Resources

• How to Use Text Cleaning Formulas in Excel (LEFT, RIGHT, MID, LEN, TRIM, CLEAN)
• Top 15 Basic Excel Formulas Every Beginner Should Know
• How to Allow Input Number and Text Only in Excel with Data Validation
• Essential Excel Keyboard Shortcuts Every User Should Know
• Free Download PDF - 50 Popular Excel Formulas Cheatsheet (Khmer Language)