TEXT Function
Description TEXT function converts a numeric value to text and lets you specify the display formatting by using special format strings. This […]
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 […]
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 […]
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 […]
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 […]
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. […]
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 […]
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 […]