On Sun, 20 Aug 2006 02:58:01 -0700, JayW
wrote:

Simple I thought, but can anyone help

I have a column of cells with similar to the following text.

First Marine Avenue 18 1303 11 1

There will always be a final 4 groups of text numbers, each with a space
between, but each having different number of numbers (this particular
sequence has 2,4,2,1 - but others may be different, but always 4 groups)

The true text ( a series of Road names are potentiaaly all different, having
a sequence of words that may be up to 5 words long before the numbers start)

I need to extract the 4 groups of numbers into seperate cells, leaving the
Road name text in a singe cell. I would then have a table of 5 columns, the
first the Road text, and the next 4 columns being the group of numbers, which
I would then format as numbers.


I neglected to note that to convert the text strings, which my previous
formulas will produce, to numbers, precede each formula with a double unary.

In other words:

=--REGEX.MID(A1,...

or

=--MID(A1, ...

depending on if you use the morefunc.xll formulas, or the built-in worksheet
functions.
--ron