Text Functions

Back

ASC : Changes full-width English letters or katakana within a character string to half-width characters
BAHTTEXT : Converts a number to text, using the ß (baht) currency format
CHAR : Returns the character specified by the code number
CLEAN : Removes all nonprintable characters from text
CODE : Returns a numeric code for the first character in a text string
CONCATENATE : Joins several text items into one text item
DOLLAR : Converts a number to text, using the $ (dollar) currency format
EXACT : Checks to see if two text values are identical
FIND, FINDB : Finds one text value within another (case-sensitive)
FIXED : Formats a number as text with a fixed number of decimals
JIS : Changes half-width English letters or katakana within a character string to full-width characters
LEFT, LEFTB : Returns the leftmost characters from a text value
LEN, LENB : Returns the number of characters in a text string
LOWER : Converts text to lowercase
MID, MIDB : Returns a specific number of characters from a text string starting at the position you specify
PHONETIC : Extracts the phonetic (furigana) characters from a text string
PROPER : Capitalizes the first letter in each word of a text value
REPLACE, REPLACEB : Replaces characters within text
REPT : Repeats text a given number of times
RIGHT, RIGHTB : Returns the rightmost characters from a text value
SEARCH, SEARCHB : Finds one text value within another (not case-sensitive)
SUBSTITUTE : Substitutes new text for old text in a text string
T : Converts its arguments to text
TEXT : Formats a number and converts it to text
TRIM : Removes spaces from text
UPPER : Converts text to uppercase
VALUE : Converts a text argument to a number