Text Functions
- 2 minutes to read
This document briefly describes text functions implemented in the ASPxSpreadsheet.
BAHTTEXT(number)- Converts a number to text, using the ß (baht) currency format.
CHAR(number)Returns the character specified by a number within the character set used by your system.
A number must be between 1 and 255.
CLEAN(text)Removes all non-printable characters from text.
The CLEAN function was designed to remove the first 32 nonprinting characters in the 7-bit ASCII code (values 0 through 31) from text.
CODE(text)- Returns the numeric code for the first character of a string.
CONCATENATE(text1, [text2], ...)- Joins text strings.
DOLLAR(number, [decimals])- Converts a number into text and applies a currency format.
EXACT(text1, text2)- Checks if two strings are exactly the same.
FIND(find_text, within_text, [start_num])- Finds a substring or a character in a string.
FIXED(number, [decimals], [no_commas])- Rounds a number to certain number of decimal places and converts it to text.
LEFT(text, [num_chars])- Returns a specified number of characters from the start of a text string.
LEN(text)- Returns the length of a text string.
LOWER(text)- Converts all characters to lower case.
MID(text, start_num, num_chars)- Returns a specified number of characters from the middle of a text string.
NUMBERVALUE(Text, [Decimal_separator], [Group_separator ])- Converts text to a number, in a locale-independent way.
PROPER(text)- Converts all characters in a text string to proper case (first letter in a word is upper case and other letters are lower case)
REPLACE(old_text, start_num, num_chars, new_text)- Replaces all or part of a text string with another string starting from a specified position.
REPT(text, number_times)- Returns a string that is composed of a specified text string, repeated a number of times.
RIGHT(text,[num_chars])- Returns a specified number of characters from the end of a text string.
SEARCH(find_text,within_text,[start_num])- Returns the position of a character or text string in a specified text string.
SUBSTITUTE(text, old_text, new_text, [instance_num])- Substitutes all occurrences of a search text string within an original text string with the replacement text.
T(value)- Checks if the value is text.
TEXT(value, format_text)- Converts a value to text.
TRIM(text)- Removes spaces at the start and end of a text string.
UNICODE(text)- Returns the number (code point) corresponding to the first character of the text.
UPPER(text)- Converts all characters to upper case.
VALUE(text)- Converts a text string into a numeric value.