The VBA Split Function is used is to split a string of text into an array. The text is split based on a given delimiter – e.g. a comma, space, colon etc. For example, imagine we have the following string: “Apple:Orange:Pear:Plum” You can see that each item separated by the colon sign. We call the […]