TEXT Function

Description TEXT function converts a numeric value to text and lets you specify the display formatting by using special format strings. This...
 0

T Function

Description T function returns the text referred to by value. Syntax T(value) Parameters value Required. The value you want to test. Remarks...
 0

VALUE Function

Description VALUE function converts a text string that represents a number to a number. Syntax VALUE(text) Parameters Text Required. The text enclosed...
 0

RIGHT, RIGHTB Function

Description RIGHT returns the last character or characters in a text string, based on the number of characters you specify. RIGHTB returns...
 0

SUBSTITUTE Function

Description SUBSTITUTE function substitutes new_text for old_text in a text string. Use SUBSTITUTE when you want to replace specific text in a...
 0

REPLACE, REPLACEB Function

Description REPLACE function replaces part of a text string, based on the number of characters you specify, with a different text string....
 0

PROPER Function

Description PROPER Function capitalizes the first letter in a text string and any other letters in text that follow any character other than...
 0

UPPER Function

Description UPPER Function converts all lowercase letters in a text string to uppercase. If you want to converts all uppercase letters in a text...
 0