Friends,
i have a address in one cell ie., list of address provided to me in spreadsheet.
eg. 14 thames street sharon sharonshire england 14h 24t.
so this should split as in separate column NO. "14" and in next column field called Street as Thames street",
field called County as "Sharon", field called town as "Sharonshire", city as "england" and Post code as 14h 24t.
So address in single cell should break in the respective fields which i have given.
fields are No. , Street, County, Town, City & Postcode.

pls help me with your possible ideas...
any small ideas would also be help full....

thanks guys.