Category - Text

List of user defined functions

ACRONYMReturns the first letter of each word.
CONTAINSReturns whether a string is contained inside another string.
EXTRACTNUMBERSReturns only the numbers from a text string.
EXTRACTTEXTReturns only the text from a text string.
ISLIKEReturns whether a particular cell contains a string that matches a certain pattern.
LASTWORDReturns the last word from a text string.
NUMBERTOROMANReturns the text string converting a binary number to a roman numeral.
ORDINALReturns a number with its corresponding ordinal abbreviation.
SPELLNUMBERReturns the word equivalent for a numerical number.
SPELLNUMBERREVERSEReturns the numerical number equivalent for a number written as text.
WORDCOUNTReturns the number of words in a particular cell.
WORDGETReturns 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.
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.
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.

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext