Category - Text

List of user defined functions

ACRONYM	Returns the first letter of each word.
CONTAINS	Returns whether a string is contained inside another string.
EXTRACTNUMBERS	Returns only the numbers from a text string.
EXTRACTTEXT	Returns only the text from a text string.
FIRSTWORD	Returns the first word from a text string.
ISLIKE	Returns whether a particular cell contains a string that matches a certain pattern.
LASTWORD	Returns the last word from a text string.
NUMBERTOROMAN	Returns the text string converting a binary number to a roman numeral.
ORDINAL	Returns a number with its corresponding ordinal abbreviation.
REMOVENUMBERS	Returns any numbers from a text string.
REMOVESPACES	Returns a text string with any spaces removed.
REMOVETEXT	Returns a text string with a substring removed.
REVERSE	Returns the cell contents with all the characters reversed.
SCRAMBLE	Returns the contents of a cell with all the characters in a random order.
SPELLNUMBER	Returns the text after converting a number into words.
SPELLNUMBERREVERSE	Returns the value after converting words into a number.
TRANSLATE	Returns the text translated into another language.
WORDCOUNT	Returns the number of words in a particular cell.
WORDGET	Returns the nth element of a string that uses a separator character.

ACRONYM Returns the first letter of each word.
CONTAINS Returns whether a string is contained inside another string.
EXTRACTNUMBERS Returns only the numbers from a text string.
EXTRACTTEXT Returns only the text from a text string.
FIRSTWORD Returns the first word from a text string.
ISLIKE Returns whether a particular cell contains a string that matches a certain pattern.
LASTWORD Returns the last word from a text string.
NUMBERTOROMAN Returns the text string converting a binary number to a roman numeral.
ORDINAL Returns a number with its corresponding ordinal abbreviation.
REMOVENUMBERS Returns any numbers from a text string.
REMOVESPACES Returns a text string with any spaces removed.
REMOVETEXT Returns a text string with a substring removed.
REVERSE Returns the cell contents with all the characters reversed.
SCRAMBLE Returns the contents of a cell with all the characters in a random order.
SPELLNUMBER Returns the text after converting a number into words.
SPELLNUMBERREVERSE Returns the value after converting words into a number.
TRANSLATE Returns the text translated into another language.
WORDCOUNT Returns the number of words in a particular cell.
WORDGET Returns the nth element of a string that uses a separator character.