How to use the T function
Author: Oscar Cronquist Article last updated on June 16, 2018
The T function returns a text value if the argument is a text value.
Formula in cell C3:
=T(B3)
The T function returns nothing for numbers, dates or boolean values.
Excel Function Syntax
T(value)
Arguments
value | Required. The value you want to evaluate. |
Comments
This function is provided for compatibility with other software.
Functions in 'Text' category
The T function function is one of many functions in the 'Text' category.
Converts full-width (double-byte) characters to half-width (single-byte) characters.
Converts a number to the corresponding ANSI character determined by your computers character set.
Deletes the first 32 nonprinting characters in 7-bit ASCII code in your argument.
Returns the corresponding number for the first character based on your computers character set. (PC- ANSI)
Concatenates values from multiple cells.
Joins text strings.
Checks if two values are precisely the same, it returns TRUE or FALSE. The EXACT function also considers upper case and lower case letters.
Returns the position of a specific string in another string, reading left to right. Note, the FIND function is case-sensitive.
Extracts a specific number of characters always starting from the left.
Returns the number of characters in a cell value.
Converts a value to lower case letters.
Returns a substring from a string based on the starting position and the number of characters you want to extract.
Repeats a specific text a chosen number of times.
Extracts a specific number of characters always starting from the right.
Returns the number of the character at which a specific character or text string is found reading left to right (not case-sensitive)
Replaces a specific text string in a value. Case sensitive.
Returns a text value if the argument is a text value.
Converts a value to text in a specific number format.
Extracts a string after a specific substring in a given value.
Extracts a string before a specific substring from a given value.
Combine text strings from multiple cell ranges.
Splits a string into an array based on delimiting values.
Deletes all blanks or space characters except single blanks between words in a cell value.
Calculates a character based on a Unicode number.
Returns a Unicode number based on a character.
Converts a value to upper case letters.
Converts a text string that represents a number to a number.
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form