How to use Excel T Function


T function are text/string function in excel. It is used to retrieve text from a given text value and also retrieves blank strings for numbers, logical values, dates etc. It is a worksheet function and can be entered in the cell in which value is required.





Value: Value or reference to a cell containing value whose text will be returned.


  • This function gives empty  strings for numbers, logical values, dates etc


  • In this example, text values are entered in column A and T function is used to retrieve these values in column B. For number, dates etc. empty string is displayed.

Leave a Comment

Your email address will not be published. Required fields are marked *