noob stuck with moving/deleting multiple peices of data

[Jerwood]

Hey guys, So I'm fairly new to exel, recently started a business and trying my hardest to get my head around it.
I've had a look around online and cant seem to find a tutorial for what I want to do, (probably not using the right lingo in searches)
So, I'm using a scraper to gather mailing list data for my prospects (farmers) and I'm currently manually changing every individual data line. I'll Show you Exacly what I'm Doing

This is my raw data as I receive it from the scraper
\1

I then Manually format it by deleting "United Kingdom" and copy and pasting the Postcode into my desired field
This is some formatted data, just so its clear what i'm trying to do
\1

If there is anyway you know I could speed this process up please help!
I no nothing about excel at all so if I need backround knowledge in an area to do this the links to good guides/tutorials would be much appriciated!