View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JayW JayW is offline
external usenet poster
 
Posts: 8
Default Extracting part of Text from one cell to another

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.


--
JayW, Hants, UK