Excel Snippets

EXCEL VBA BUILT-IN FUNCTIONS

String Functions

FUNCTIONDESCRIPTION
- joins two or more elements separated by a delimiter
- returns the number of characters in a string (length) or bytes to store the variable type
- returns a user-specified number of characters on the left-side of an expression
- returns a user-specified number of characters on the right-side of an expression
- returns a substring of a user-specified length from the middle of an expression