How to Use T Formula in Excel (Video in Khmer)

Hello everyone! Today i will show you how to use T formula in Microsoft Excel.

T formula is one of the simplest Excel functions. Its job is very straightforward: return text if the cell contains text, otherwise return empty string "".

🛠️ Formula Syntax & How It Works

=T(value)

• value: The cell or value you want to check. It can be a number, date, text, error, or empty cell.

How it works:

• If value is text → Return that text.
• If value is number/date → Return empty text "".
• If value is error → Return that error (e.g., #N/A).

📊 Simple Examples

Let's assume you have data like this:

Example 1: Check Text

=T(A1)

Result: "Khmer" (Because A1 is text)

Example 2: Check Number

=T(A2)

Result: "" (Because A2 is number)

Example 3: Check Date

=T(A3)

Result: "" (Because date is treated as number in Excel)

Example 4: Check Error

=T(A4)

Result: #N/A (Error value)

Example 5: Check Empty Cell

=T(A5)

Result: "" (Empty)

💡 Pro Tips for T Formula

1. Clean Up Mixed Data: Use T together with IFERROR or IF to clean up mixed data. Example: =IF(T(A1)="", "", T(A1)) will return empty instead of error.
2. Use ISBLANK or LEN instead? For checking empty cells, ISBLANK(A1) or LEN(A1)=0 are often clearer than =T(A1)="". But T works well for mixed data.
3. Combine with CONCAT or &: You can use T to extract text from mixed range before joining: =CONCAT(T(A1), ", ", T(A2), ", ", T(A3)).

📚 Related Tutorials

• How to Connect Text Values in Excel (CONCAT, &)
• How to Change Text Case (UPPER, LOWER, PROPER) in Excel
• Top 15 Basic Excel Formulas for Beginners