TEXT Function

Description TEXT function converts a numeric value to text and lets you specify the display formatting by using special format strings. This function is useful in situations where you want to display numbers in a more readable format, or you want to combine numbers with text or symbols. Syntax TEXT(value,…

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 If value is or refers to text, T returns value. If value does not refer to text, T returns “” (empty text). You do not generally need to…

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 in quotation marks or a reference to a cell containing the text you want to convert. Remarks Text can be in any of the constant number, date, or…

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 the last character or characters in a text string, based on the number of bytes you specify. What is the difference between RIGHT and RIGHTB? RIGHT is intended…

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 text string; use REPLACE when you want to replace any text that occurs in a specific location in a text string. Syntax SUBSTITUTE(text, old_text, new_text, [instance_num]) Parameters Text…

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. REPLACEB function replaces part of a text string, based on the number of bytes you specify, with a different text string. Use REPLACE when you want to replace…

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 a letter. Converts all other letters to lowercase letters. If you want to converts all uppercase letters in a text string to lowercase, please use LOWER function. If you want…

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 string to lowercase, please use LOWER function. Syntax UPPER(text) Parameters Text Required. The text you want converted to uppercase. Text can be a reference or text string. Examples The…