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 word equivalent for a numerical number. |
SPELLNUMBERREVERSE | Returns the numerical number equivalent for a number written as text. |
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 word equivalent for a numerical number. |
SPELLNUMBERREVERSE Returns the numerical number equivalent for a number written as text. |
WORDCOUNT Returns the number of words in a particular cell. |
WORDGET Returns the nth element of a string that uses a separator character. |
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited TopPrevNext