Text Functions

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.
ISLIKE 
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.
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
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.

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