Text Functions Flashcards
This function converts a normal number to the character it represents in the ANSI character set used by Windows.
=CHAR
This function removes any non-printable characters from text.
=CLEAN
This function shows the ANSI value of a single character, or the first character in a piece
=CODE
This function joins separate pieces of text into one item.
=CONCATENATE
This function converts a number into a piece of text formatted as currency.
=DOLLAR
This function compares two items of text and determine whether they are exactly the same.
=EXACT
This function looks for a specified letter inside another piece of text.
=FIND
This function converts a numeric value to text.
=FIXED
This function displays a specified number of characters from the left-hand side of a piece of text.
=LEFT
This function counts the number of characters, including spaces and numbers, in a piece of text.
=LEN
This function converts all characters in a piece of text to lower case.
=LOWER
This function picks out a piece of text from the middle of a text entry.
=MID
This function converts the first letter of each word to uppercase, and all subsequent letters are converted to lowercase.
=PROPER
This function replaces a portion of text with a new piece of text.
=REPLACE
This function repeats a piece of text a specified number of times.
=REPT
This function displays a specified number of characters from the right hand side of a piece of text.
=RIGHT
This function replaces a specified piece of text with a different piece of text.
=SUBSTITUTE
This function examines an entry to determine whether it is text or not.
=T
This function converts a number to a piece of text.
=TEXT
This function removes unwanted spaces from a piece of text.
=TRIM
This function converts all characters in a piece of text to upper case.
=UPPER
This function converts a piece of text which resembles a number into an actual value.
=VALUE
