This is the third in a series of discussions on the techniques available for extracting numbers from an alphanumeric string.

In the first instalment in this series (which can be found here) I looked at extracting consecutive numbers which appear at the start of the string, e.g. 123ABC456.

In the second instalment (here) I looked at extracting consecutive numbers which appear at the end of the string, e.g. 123ABC456.

In this post I will demonstrate a technique for extracting all numbers from a string where:

• The string in question consists of a mixture of numbers, letters and special characters
• The numbers may appear anywhere within that string
• Decimals within the string are to be returned as such
• The desired result is to have all numbers returned to separate cells

More…