Excel: Extracting a sequence of numbers within a string

Good afternoon, I have a series of variable length strings in an Excel list that look a bit like this:

promote Trans.no: 1173331 by bobsmith
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

This question generated 20 answers. To proceed to the answers, click here.

This thread is current as of July 30, 2014.

For more resources for Microsoft Excel