This is the second 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 this post I will concentrate on techniques for extracting numbers from a string where:

- The numbers are consecutive
- The consecutive string of numbers is found at the very end of the string
- The desired result is to have those consecutive numbers returned to a single cell

As previously, for each of the given solutions, we need to test its soundness in two separate cases: firstly, where there are **no** numbers elsewhere in the string, e.g. ABC**456** and secondly, where there are **some** numbers elsewhere in the string, either at the start, e.g. 123ABC**456**, or in the middle, e.g. ABC123DEF**456**.