How to use the T Function in Excel
Description
The T Function is categorized as Text Function in Excel. This function checks whether the supplied value is text or not. If it is text it returns the same value otherwise it returns empty text string.
The T function takes one argument which can be a text string or any cell reference or a number. It can also be used as a part of a formula.
Syntax
The syntax of RIGHT function is =T(value)
Argument or Parameter
value (Required)- can be a text string or cell reference or a number from which we want extract the text string.
- If the num_chars is omitted, it will assume it as 1.
- If the num_chars is 0, then it will return blank.
- If the num_chars must be greater than 0 to return any text.
Returns
The RIGHT function returns specified number of character from the right most end of the given text string.
Example
Example-1
In this example below we have different types of values such text, date, time, logical values like TRUE & FALSE, number with different formats and also error values. So we want to extract the values which are text and rest will return empty text string (""). In B2 type =T(A2) and drag the formula till row 14. We can see the result that only text values are returned as they are and rest returned empty text string.
Example-2
In this example, we have two field First Name and Last Name. We can see some cell contains text and some cell contains numbers and we need to join the text but not numbers. So if we do it in simple way we can do =A3&" "&B3, the result is shown in column C, where numbers are added. But we need to remove these numbers, so the formula will be =T(A3)&" "&T(B3). The result is shown in column D. So this how we use T function.
Notes
- T functions return text from a supplied value if the value is text else empty text ("").
- In most cases this function is unnecessary.
- This function is provided for compatibility with other spreadsheet programs.
********************************* ~:Support Our Work Financially:~ *********************************
Project File Type: Free
If you think this tutorial helps you to solve your problem and add value to your work, Buy me a Coffee..
************************************************************************************************
|
|
||||
|
CHAR |
CLEAN |
CONCATENATE |
||
|
DOLLAR |
EXACT |
FIND |
FIXED |
LEFT |
|
LEN |
MID |
NUMBERVALUE |
||
|
REPLACE |
REPT |
RIGHT |
SEARCH |
SUBSTITUTE |
|
T |
TEXT |
TRIM |
UNICHAR |
UNICODE |
|
UPPER |
VALUE |
|
|
|
0 Comments