EXCEL VBA BUILT-IN FUNCTIONS
String Functions
FUNCTION | DESCRIPTION |
---|---|
Join | - joins two or more elements separated by a delimiter |
Len | - returns the number of characters in a string (length) or bytes to store the variable type |
Left | - returns a user-specified number of characters on the left-side of an expression |
Right | - returns a user-specified number of characters on the right-side of an expression |
Mid | - returns a substring of a user-specified length from the middle of an expression |