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.
FIRSTWORDReturns the first word 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.
REMOVENUMBERSReturns any numbers from a text string.
REMOVESPACESReturns a text string with any spaces removed.
REMOVETEXTReturns a text string with a substring removed.
REVERSEReturns the cell contents with all the characters reversed.
SCRAMBLEReturns the contents of a cell with all the characters in a random order.
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.
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.

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