Well thanks for the replies but I solved the problem and have it working nicely.
But for anyone interested example strings would be.
~40,product one~0,misspelled product~0,item~0,~3
varying length product~0,product one~0,product 137~5,item2~14
I'm new to VBA, as in I've been trying to learn it to solve a problem over the past 2 days. I have experience in Java so that seems to have kind of helped.
Anyways, the problem I'm trying to solve is extracting varying lengths of text between numbers in a string. I want to be able to use a...