Text Functions
- 3 minutes to read
This document describes text functions supported by the WPF Spreadsheet control.
Name | Description | Syntax |
---|---|---|
Converts a number to Thai text and appends “Baht” to the end of the text. | BAHTTEXT | |
Returns the character specified by a number within the character set used by your system. | CHAR A number must be between 1 and 255. | |
Removes all non-printable characters from text. | CLEAN The CLEAN function was designed to remove the first 32 nonprinting characters in the 7-bit ASCII code (values 0 through 31) from text. In the Unicode character set, there are additional nonprinting characters (values 127, 129, 141, 143, 144, and 157). | |
Returns a numeric code for the first character in a text string. | CODE | |
Combines text from multiple ranges and/or strings without a delimiter. | CONCAT | |
Joins two or more text strings into one string. | CONCATENATE | |
Converts a number to text using currency format, with the decimals rounded to the specified number of places. | DOLLAR | |
Determines whether two strings are exactly the same. | EXACT | |
Returns the starting position of one text string within another text string. The function is case-sensitive. | FIND | |
Rounds a number to the specified number of decimals and returns the result as text with or without commas. | FIXED | |
Returns a specified number of characters from the start of a text string. | LEFT | |
Returns the number of characters in a text string. | LEN | |
Converts all uppercase letters in a text string to lowercase. | LOWER | |
Returns a specified number of characters from a text string starting at the position you specify. | MID | |
Converts text to a number, in a locale-independent way. | NUMBERVALUE | |
Converts all characters in a text string to proper case (the first letter in each word is uppercase and all other letters are lowercase). | PROPER | |
Replaces part of a text string with another string starting from a specified position. | REPLACE | |
Repeats text a given number of times. | REPT | |
Returns a specified number of characters from the end of a text string. | RIGHT | |
Returns the position of a character or text string within a specified text string. This function is not case-sensitive. | SEARCH | |
Substitutes new text for old text in a text string. | SUBSTITUTE | |
Returns the text referred to by value. If value does not refer to text, T returns “” (empty text). | T | |
Converts a value to text in a specific number format. | TEXT | |
Combines text strings using a specified delimiter. | TEXTJOIN | |
Removes all spaces from text except for single spaces between words. | TRIM | |
Returns the number (code point) corresponding to the first character of text. | UNICODE | |
Converts text to uppercase. | UPPER | |
Converts a text string that represents a number to a number. | VALUE |