noob stuck with moving/deleting multiple peices of data

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!

it begins with posting an excel file, without confidential information.

please also add the desired (expected) result.

This formula will split the Postal code from the text in Column B. Enter in C2 and copy down:

Formula:

Please Login or Register  to view this content.

Now, select and copy the result in column C then Paste Values. This will leave the codes without the formulae still there.

Select column B. Click on Home Tab, Find & Select, Replace, Replace With and enter the following exactly ????????, United Kingdom
In Replace With, leave blank.
Replace All.

This is the result:

	A	B	C
1	Name	Address	Postcode
2	A Coombes	10 Shaftesbury Rd, Wilton, Salisbury, Wiltshire	SP2 0DR
3	A E Nesbitt Farms Ltd	North Standen House, North Standen, Hungerford, Berkshire	RG17 0QZ
4	A T Christian Farmer	Walkeridge Farm, Overton, Basingstoke, Hampshire	RG25 3EL
5	Ablington Farm	Ablington, Figheldean, Salisbury	SP4 8JX
6	Alderbury Farm	Witherington Rd, Alderbury, Salisbury	SP5 3DL
7	Alderstone Farm	Dean Ln, Whiteparish, Salisbury	SP5 2RN

Originally Posted by newdoverman

This formula will split the Postal code from the text in Column B. Enter in C2 and copy down:

Formula:

Please Login or Register  to view this content.

Now, select and copy the result in column C then Paste Values. This will leave the codes without the formulae still there.

Select column B. Click on Home Tab, Find & Select, Replace, Replace With and enter the following exactly ????????, United Kingdom
In Replace With, leave blank.
Replace All.

This is the result:

	A	B	C
1	Name	Address	Postcode
2	A Coombes	10 Shaftesbury Rd, Wilton, Salisbury, Wiltshire	SP2 0DR
3	A E Nesbitt Farms Ltd	North Standen House, North Standen, Hungerford, Berkshire	RG17 0QZ
4	A T Christian Farmer	Walkeridge Farm, Overton, Basingstoke, Hampshire	RG25 3EL
5	Ablington Farm	Ablington, Figheldean, Salisbury	SP4 8JX
6	Alderbury Farm	Witherington Rd, Alderbury, Salisbury	SP5 3DL
7	Alderstone Farm	Dean Ln, Whiteparish, Salisbury	SP5 2RN

Thanks very much for the reply, THIS WORKS PERECTLY, YOU HAVE SAVED ME HOURS OF WORK!!!!
+1 +1 +1!!!!

Thank you for the feedback.

Good luck.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.