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. |
|
| SPELLNUMBERREVERSE - Return the value after converting words into a number. |
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 |
|
| ?? |
Return the acronym from a text string |
| You can return the acronym for up to three words by using these formulas. |
|
| link - https://chandoo.org/wp/get-initials-from-name-excel-formula FIND IFERROR LEFT LEN MID SEARCH SUBSTITUTE ACRONYM - Returns the first letter of each word. |
Return the concatenation of values in a particular range |
| ?? |
|
| CONCAT TEXTJOIN |
Return the longest string in a column |
| ?? |
|
| does not work with multiple columns |
Return the most frequently occurring word |
| ?? |
|
| MODE INDEX MATCH |
Return the number equivalent for a number written as text |
| This user defined function can return the number equivalent for a number written as text. |
|
| SPELLNUMBERREVERSE - Return the value after converting words into a number. |
Return the second word |
| You can return the second word from a text string by using this formula |
|
| If there is only one word then this formula returns an empty string. link - https://www.atlaspm.com/toms-tutorials-for-excel/ COUNT FIND IF LEFT LEN OR REPLACE TRIM |
Return the text converted to sentence case |
| The text string converted to a Sentence Case. |
|
| LEFT LEN LOWER RIGHT UPPER |
Return the value from the cell above |
| The value in the cell directly above |
|
| INDIRECT ADDRESS ROW COLUMN |
Return the word equivalent for a numerical value |
| This user defined function can return the word equivalent for a numerical value. |
|
| SPELLNUMBER - Returns the text after converting a number into words. |
Return the words in reverse order |
| You can return the words of a text string in reverse order by using this formula. |
|
| LEFT LEN RIGHT SEARCH REVERSE - Returns the contents of a cell with all the characters reversed. |
© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited Top