#12918530, By MMMarmite Quick Excel Help

MMMarmite 16 Jun 2021 15:27:21 1,659 posts
Seen 1 day ago
Registered 15 years ago

If they were all UK addresses you could do something like, find the first number then take anything left of that -2 as the city and anything right +2 as the postcode - since all UK postcodes start with 2 letters and then a number it's a common pattern you can use.

For quite a few other countries you may be able to just search for the first number and split on that.

This all assumes you've already split out the other address details containing numbers like house number, street, etc...