Splitting Address Out With Spaces

[Alex501]

Hi

I've been given a large amount of data to transfer from one system to another, the problem I have is that the original data is space delimitited, for example;

12 High Street Leeds
Flat 1 28 New Street Openshaw Manchester
P.O. Box 255 15 Low Street Hackney London

Other than using text to columns to split out the data and then reconstitute it slowly, is there any other way using a formula that I can split it into Address1, Address2, Town, Coounty?

Thanks

Alex

 

[Peter_SSs]

.. is there any other way using a formula that I can split it into Address1, Address2, Town, Coounty?

Virtually impossible as County, Town and Street can all be single or multiple words.