Text Formulas

Abbreviate name and words*	Placeholder
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 acronym from a text string	Text - Return
Return the first letter of each word	Text - Return
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 second word	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 value	Text - Return
Return the words in reverse order	Text - Return
Return two strings joined together	Text - Display

Abbreviate name and words* Placeholder
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 acronym from a text string Text - Return
Return the first letter of each word Text - Return
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 second word 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 value Text - Return
Return the words in reverse order Text - Return
Return two strings joined together Text - Display