Function T()

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.

Share on Facebook Share on Twitter Share on Google Plus

About Dhakkanz

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.