Article Finds one text string (find_text) within another text string (within_text), and returns the number of the starting position of find_text, from the first charact...

Article Converts a text string that represents a number to a number. Syntax VALUE ( text ) Text   is the text enclosed in quotation marks or a column reference containi...

Article Converts a number to text using currency format, with the decimals rounded to the specified place. The format used is $#,##0.00_);($#,##0.00). Syntax USDOLLAR (...

Article Compares two text strings and returns the logical value TRUE if they are exactly the same, FALSE otherwise. EXACT is case-sensitive. Use EXACT to test text bein...

Article Converts text to uppercase. Syntax UPPER ( text ) Text   is the text you want converted to uppercase. Text can be a column reference or text string. Example For...

Article Removes all spaces from text except for single spaces between words. Use TRIM on text that you have received from another application that may have irregular sp...

Article Converts a number to text using currency format, with the decimals rounded to the specified place. The format used is $#,##0.00_);($#,##0.00). Syntax DOLLAR ( n...

Article Converts a value to text in a specific number format. Syntax TEXT ( value , format_text ) Value   is a numeric value, a formula that evaluates to a numeric valu...

Article Returns a numeric code for the first character in a text string. The returned code corresponds to the character set used by your computer. Syntax CODE ( text ) ...

Article Returns the text referred to by value. Syntax T ( value ) Value   is the value you want to test. Remarks If value is or refers to text, T returns value. If valu...

Article Removes all nonprintable characters from text. Use CLEAN on text imported from other applications that contains characters that may not print with your operatin...

Article Returns the character specified by a number. Use CHAR to translate code page numbers you might get from files on other types of computers into characters. Synta...

Article In Microsoft SharePoint Services, use the CONCATENATE function to join several text strings into one string.

Article Repeats text a given number of times. Use REPT to add a number of instances of a text string. Syntax REPT ( text , number_times ) Text   is the text you want to...

Article RIGHT returns the last characters in a text string, based on the number of characters you specify. Syntax RIGHT ( text , num_chars ) Text   is the text string c...

Article REPLACE replaces part of a text string, based on the number of characters you specify, with a different text string. Syntax REPLACE ( old_text , start_num , num...

Article For Double-byte character set (DBCS) languages, changes full-width (double-byte) characters to half-width (single-byte) characters. Syntax ASC ( text ) Text   ...

Article Capitalizes the first letter and any other letters that follow a non-letter character in a text string. Converts all other letters in the text string to lowerca...

Article SEARCH returns the number of the character at which a specific character or text string is first found, beginning with start_num. Use SEARCH to determine the lo...

Article Rounds a number to the specified number of decimals, formats the number in decimal format using a period and commas, and returns the result as text. Syntax FIXE...

Article LEFT returns the first character or characters in a text string, based on the number of characters you specify. Syntax LEFT ( text , num_chars ) Text   is the t...

Article LEN returns the number of characters in a text string. Syntax LEN ( text ) Text   is the text whose length you want to find. Spaces count as characters. Example...

Article Converts all uppercase letters in a text string to lowercase. Syntax LOWER ( text ) Text   is the text you want to convert to lowercase. LOWER does not change c...

Article MID returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify. Syntax MID ...