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 :

Where,

• value – value that you want to test

 

Example of T Function in Excel

Formula

• 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