Home
BetterSolutions.com
Online Documentation
Microsoft Office Excel
Microsoft Office Word
JavaScript Programming
VBA Programming
C# Programming
Microsoft Office Excel
Workbooks
Worksheets
Rows Columns
Cells Ranges
Data Validation
Data Analysis
Pivot Tables
Power Query
Search Excel ...
Functions
User Defined
Formulas
Dynamic Formulas
Reviewing
Track Changes
Named Ranges
Conditional Format
Microsoft Word
Tables
Charts
Dates Times
Formatting
Illustrations
Layout
Importing
XML
Microsoft PowerPoint
Ribbon
Options
Shortcut Keys
Protection
Add-ins
Macros
Templates
Quant Finance
Microsoft Outlook
Microsoft Office Excel
Worksheet Functions List
Ribbon Tabs Explained
Keyboard Shortcut Keys
Best Practices
Search Excel ...
VBA Programming
Visual Basic Editor
Best Practices
Macros
Syntax
Arrays
Collections
Error Handling
Debugging
Search VBA ...
Data Types
Variables
Strings
Numbers
Dates
Text Files
Directories
XML
Questions
Functions
Subroutines
MsgBox
InputBox
Userforms
Controls
Events
Databases
C# Programming
Ribbon
Options
Shortcut Keys
Enumerations
Class Modules
References
Web Services
SQL
JS Programming
VBA Programming
Complete Functions List
Recording Macros
Syntax And Loops
Best Practices
Search VBA ...
Bespoke Development
Office Add-in Development
JavaScript Office Add-ins
VSTO and C# Integration
Macros and VBA Programming
High Value Consultancy
Get In Touch
Excel
>
Formulas
Microsoft Excel
Formulas
User FAQs ...
Shortcut Keys ...
Troubleshooting ...
Different Error Types ...
Complete List
Categories ...
Counting
Summing
Lookup
Conditional
Date & Time
Formatting
Number
Statistical
Text
Filtering
Data Validation
Other
Counting Formulas
Summing Formulas
Lookup Formulas
Inserting ...
Calculation ...
Auditing ...
Error Checking ...
Dynamic Formulas ...
Array Formulas ...
Updates ...
Code - TypeScript
Code - VBA ...
Updated: 01 June 2023
01 June 2023
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 number
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 number
Text - Return
Return the words in reverse order
Text - Return
Return two strings joined together
Text - Display
© 2023 Better Solutions Limited.
All Rights Reserved.
© 2023
Better Solutions Limited
Top