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.
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.
WORDCOUNT *Returns the number of words in a particular cell.
WORDGET *Returns the nth element of a string that uses a separator character.