TEXT FUNCTIONS

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