In trying to find a pattern in your example, it looks like column G
always contains the post code, although it may be blank, and column F
should contain the county, although it might show the post code.
Column E contains the city name.

I have to display some of my American ignorance he is a post code
always either 7 or 8 characters long? I see two examples: 3 or 4
alphanumeric characters, a space, then 3 alphanumeric chars. If that
is universally true, you can use those to your advantage. I'll see if
I can work up a solution- I know you're getting ready to leave for the
day.

Dave O