Good afternoon, I have a series of variable length strings in an Excel list that look a bit like this:
I want to be able to extract the numeric element of the string which is usually, but not always eight characters I know however that the number will always be preceded by "Trans.no: " and always followed by " by " as in the above example. Any suggestions? As always, thanks in advance Pete
promote Trans.no: 1173331 by bobsmith
This question generated 20 answers. To proceed to the answers, click here.
This thread is current as of July 30, 2014.