T()

This function is used to check whether a cell contains any text or not, and if it contains text that text should be pulled out to cell in which this function is used.

Though this function is very rarely used, it has good utility in its application

Syntax:

= T (Cell)

Cell = cell that is to be checked for containing text

Example:

Below are some examples to illustrate the usage of Proper() function. For these illustrations let us assume that cell A1 contains text - Excel Matic, cell A2 contains 25.65 and cell A3 contains Force5.

- = T(A1) - result will be - Excel Matic
- = T(A2) - result will be -
- = T(A3) - result will be - Force5
- = T("Excel Matic") - result will be - Excel Matic
- = T(30.77) - result will be -
- = T("30.77") - result will be - 30.77
- = T("Force5") - result will be - Force5

Note: In the above example #6, the result will be 30.77 because in the function the input itself is a text. Whenver a number is input in double quotes ( "text" ), the numeric value becomes text.

## 0 comments:

## Post a Comment