Text Formulas
| 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 concatenation of values in a particular range | 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 |
| 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 concatenation of values in a particular range 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 |
Convert a word into numbers |
| This user defined function can return the number equivalent for a number written as text. |
| * Columns=1 * Width=800 * ?? |
Return every fourth entry in a list |
| To obtain every fourth entry in a column and put them in a separate column, you can use the following formula |
| * Columns=1 * Width=800 * OFFSET(A1, ROW()*4-1, 0). |
Return the acronym from a text string |
| You can return the acronym for up to three words by using these formulas. |
| * Columns=1 * Width=800 * Columns=1 * TableWidth=Full * FirstName LastName * F L * Abbreviate Three Words * ATW * Three With Spaces * T W S |
© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited Top