This is the fourth 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. **123**ABC456.

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

In the third instalment (here) I looked at extracting all numbers from a string where each of those numbers was to be returned to a *separate* cell. For example, given the string **81**;**8.75**>@**5279**@**4**.=**45**>A?A; we extracted **81**, **8.75**, **5279**, **4** and **45** into individual cells.

In this post I will look at a technique for extracting *all* numbers from a string, but where those numbers are to be returned as a *single number* in a *single* cell.