Thanks E.Q., you are officially my favourite person of the year so far - and
you're going to be hard to beat, that was absolute genius!!!

--
Thanks
Luke


"E.Q." wrote:

I placed your data as listed in cell B3
In row c3 I entered =find("alt-ent",B3) with the quotes but using alt enter
so visually the formual looks like a carriage return between quotaion
marks.... there's probably some way to use either code() or char()... I
didn't have that though...
C3 gave me a value of 12, in D3 I entered =find("alt-ent",$B3,1+C3) and
copied that to cells E3 and F3. (This gave values of 22, 31, and 41 in d3-f3)
then in G3:
=LEFT(B3,C3-1)
in H3:
=MID($B3,C3+1,D3-C3-1)
copied that right to populate I3 and J3
then finished with this formula in K3
=RIGHT(B3,LEN(B3)-F3)
On my machine i ended up with street address in column G, Town in column H,
City in column I, "shire" in column J, and postal code in column K.
Hope that helps