Level 7 Level 9
Level 8

Text functions


23 words 0 ignored

Ready to learn       Ready to review

Ignore words

Check the boxes below to ignore/unignore words, then click save at the bottom. Ignored words will never appear in any learning session.

All None

Ignore?
ASC
Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) 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
DOLLAR
Converts a number to text, using the $ (dollar) currency format
EXACT
Checks to see if two text values are identical
FIND, FINDBs
Finds one text value within another (case-sensitive)
FIXED
Formats a number as text with a fixed number of decimals
JIS
Changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters
LEN, LENBs
Returns the number of characters in a text string
LOWER
Converts text to lowercase
PHONETIC
Extracts the phonetic (furigana) characters from a text string
REPLACE, REPLACEBs
Replaces characters within text
REPT
Repeats text a given number of times
RIGHT
Returns the rightmost characters from a text value
SEARCH, SEARCHBs
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