T Function in Excel – Test if the value is text in Excel

T Function in Excel tests if a supplied value is text and if so, returns supplied text. If not T Function returns an empty string.

Syntax of T Function in Excel :

T( value )

Where,

  • value – value that you want to test

 

Example of T Function in Excel

Formula

T Function in Excel 1

  • Row number 2 takes up the number argument and returns NULL.
  • Row number 3 takes up date argument and returns NULL.
  • Row number 5 and 6 takes up Logical argument and returns NULL.
  • Row number 4 and 7 takes up Text argument and returns the text.

Result

T Function in Excel 2

previous-small T Function in Excel                                                                                                                next_small T Function in Excel