VBA Frequently used string manipulation
Introduction
Quick examples for MID LEFT and RIGHT string functions using INSTR FIND and LEN.
How do you find the text between two search terms (Say: after a colon and before a comma)? How do you get the remainder of a word (using MID or using RIGHT)? Which of these functions use Zero-based params and return codes vs One-based? What happens when things go wrong? How do they handle empty strings, unfound results and negative numbers?
