Close the Skill Gap -> Enroll to be a Certified Financial Modeling & Valuation Analyst (FMVA)® Today!

T Function

Tests if the value provided is a text or not

What is the T Function?

The T function is categorized under Text functions. It will test if the value provided is a text or not. If it is a text, the function will return the text, otherwise, it will return an empty text string. T is one of two functions in Excel that contains only one character.

As a financial analyst, the T function is not much useful as Microsoft Excel automatically converts values as necessary. It is provided for compatibility with other spreadsheet programs.

 

Formula

=T(value)

 

The T function uses only one argument:

  1. Value (required argument) – It is the value we wish to test.

 

How to use the T Function in Excel?

To understand the uses of the T function, let us consider an example:

 

Example 1

Suppose we are given the following data:

 

T Function

 

If the cell contains anything other than text, the T function will return an empty string. Hence, we got empty cells for numbers, dates and logical value.

We get the results below:

 

T Function - Example 1

 

Example 2

Suppose we are given the data below:

 

T Function - Example 2

 

If we wish to combine the first name and last name, we will use the CONCATENATE function. However, there are zero’s in rows 4 and 5. In this scenario, the T function can be used. The formula used is shown below:

 

T Function - Example 2a

 

We get the results below:

 

T Function - Example 2b

 

If we use the CONCATENATE function in row 7, the result would be “0 Parker.” It would be untidy and of no use, hence we used the T function.

 

Click here to download the sample Excel file

 

Additional resources

Thanks for reading CFI’s guide to important Excel functions! By taking the time to learn and master these functions, you’ll significantly speed up your financial analysis. To learn more, check out these additional resources:

  • Excel Functions for Finance
  • Advanced Excel Formulas Course
  • Advanced Excel Formulas You Must Know
  • Excel Shortcuts for PC and Mac

Free Excel Tutorial

To master the art of Excel, check out CFI’s FREE Excel Crash Course, which teaches you how to become an Excel power user.  Learn the most important formulas, functions, and shortcuts to become confident in your financial analysis.

 

Launch CFI’s Free Excel Course now to take your career to the next level and move up the ladder!