On Sat, 21 Nov 2009 23:27:11 -0500, "Rick Rothstein"
wrote:

Sorry, I misread what you meant by that... I thought you were referring to
the number that the OP was after, as per his example, being at the end of
the text no matter what what in front of it.

--
Rick (MVP - Excel)

As we've both noted before, figuring out all the possible variants, given an
initial limited posting of examples, can be tough, and lead to initial
inappropriate responses.

For example, what if there could be multiple numbers, but only the last set of
numbers is wanted; but there could be text following.


--ron