How to use Excel T Function

Introduction:-

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.

.                                                                

Syntax:-

=T(Value)

Arguments:-

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

Keynotes:-

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

Examples

  • 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 Reply

Close Menu
×

Cart