How to use T function in Excel

Last modified date

Description of T function

This function will help to identify and give the same result if the given value is TEXT, if not then the result will be a blank cell.

T Function Description

Syntax:-

T Function one argument(compulsory argument) to give the value to be tested.

T Function Syntax

Application of T function in Excel

Below we can see the if the C column has TEXT same results in D column. Cells highlighted in yellow are blank because of C6 and C7 are number values.

Application of T function in Excel
S.no Sample data T function applied Result
1 Excel Excel
2 Microsoft Microsoft
3 abc123 abc123
4 123456
5 9/17/2018
6 Word Word
S.no Sample data T function applied Result
1 Excel =T(C3)
2 Microsoft =T(C4)
3 abc123 =T(C5)
4 123456 =T(C6)
5 43360 =T(C7)
6 Word =T(C8)

Click to download the sample copy

Leave a Reply

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

Post comment