Useful but easily forgotten VB functions

When you have an array but a string is all you need, use:
Join(sourcearray[, delimiter])


When you have a string of values separated by a delimiter, like a comma or a semi colon, but you need to have them in an array, use:
Split(expression[, delimiter[, limit[, compare]]])