Text Formulas

Convert a word into numbersText - Convert
Convert numbers to textText - Convert
Remove last n charactersText - Remove
Remove one wordText - Remove
Remove unwanted charactersText - Remove
Replace one character with anotherText - Replace
Replace one word with anotherText - Replace
Replace text by matchingText - Replace
Replace text by positionText - Replace
Return a substringText - Return
Return every fourth entry in a listText - Return
Return random charactersText - Display
Return the first name from a full nameText - Return
Return the first wordText - Return
Return the last name from a full nameText - Return
Return the last wordText - Return
Return the longest string in a columnText - Return
Return the middle name from a full nameText - Return
Return the most frequently occurring wordText - Return
Return the nth wordText - Return
Return the number equivalent for a number written as textText - Return
Return the number from a number and textText - Return
Return the shortest string in a columnText - Return
Return the text converted to sentence caseText - Return
Return the value from the cell aboveText - Return
Return the word equivalent for a numerical numberText - Return
Return the words in reverse orderText - Return
Return two strings joined togetherText - Display
Convert a word into numbers
Text - Convert
Convert numbers to text
Text - Convert
Remove last n characters
Text - Remove
Remove one word
Text - Remove
Remove unwanted characters
Text - Remove
Replace one character with another
Text - Replace
Replace one word with another
Text - Replace
Replace text by matching
Text - Replace
Replace text by position
Text - Replace
Return a substring
Text - Return
Return every fourth entry in a list
Text - Return
Return random characters
Text - Display
Return the first name from a full name
Text - Return
Return the first word
Text - Return
Return the last name from a full name
Text - Return
Return the last word
Text - Return
Return the longest string in a column
Text - Return
Return the middle name from a full name
Text - Return
Return the most frequently occurring word
Text - Return
Return the nth word
Text - Return
Return the number equivalent for a number written as text
Text - Return
Return the number from a number and text
Text - Return
Return the shortest string in a column
Text - Return
Return the text converted to sentence case
Text - Return
Return the value from the cell above
Text - Return
Return the word equivalent for a numerical number
Text - Return
Return the words in reverse order
Text - Return
Return two strings joined together
Text - Display

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