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.