Article For Double-byte character set (DBCS) languages, changes full-width (double-byte) characters to half-width (single-byte) characters. Syntax ASC ( text ...
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...
Article Removes all nonprintable characters from text. Use CLEAN on text imported from other applications that contains characters that may not print with your...
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 ...
Article In Microsoft SharePoint Services, use the CONCATENATE function to join several text strings into one string.
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...
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...
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...
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...
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 ...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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 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...
