Hi all,

I've got a huge spreadsheet with customer account numbers, names, and addresses, and unfortunately all the addresses are entered as free text. All of the addresses are in the UK, and basically, I need to extract the postcodes from the free text addresses and sort all of the data by postcode.

Any ideas?