On Wed, 22 Mar 2006 15:50:35 -0800, davids
wrote:

this works but it is limited say for instance my suburb is called "lane cove"
i get "lane" in its own column and "cove" in its own column is there a way to
keep "lane cove" in one cell then "NSW" in its own cell and then "2022" in
its own cell?

I think you need to present us with the possible variations in order to obtain
a coherent answer.

Will NSW always be NSW? If not, how do we differentiate it from the rest of
the string.

For example: is it always a three letter string of capital letters that
precedes a four digit number that ends the string? Or are there more
variations than that?


--ron