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
