I am trying to strip of the postcode /zip code and put in a cell on its own can someone advise the bust why to do this data below.
thank you in advance
Excel Workbook | |||
---|---|---|---|
A | |||
5 | Aberdeen AB11 8HX | ||
6 | Acocks Green B27 7UW | ||
7 | Acton W3 8HH | ||
8 | Aldershot GU11 1JG | ||
9 | Altrincham WA14 5PZ | ||
10 | Ashford TN24 0SP | ||
11 | Aylesbury HP20 1JH | ||
12 | Banbury OX16 2RL | ||
13 | Bangor LL57 4SU | ||
14 | Basildon SS14 3GD | ||
15 | Basingstoke RG21 8BJ | ||
16 | Bath BA1 3AG | ||
17 | Beckenham BR3 4TJ | ||
18 | Bedford (Midland) MK40 1QH | ||
19 | Bedford (St John's) MK42 0XE | ||
20 | Bedminster BS3 3PZ | ||
21 | Belshill ML4 1BA | ||
22 | Birmingham (Perry Barr) B44 8AA | ||
23 | Blackburn BB2 3DY | ||
24 | Bolton BL2 1HE | ||
25 | Bournemouth BH8 8BD | ||
26 | Bradford BD5 7JL | ||
27 | Braintree CM77 8YH | ||
28 | Bridgwater TA6 4DB | ||
29 | Brighton BN1 4GD | ||
30 | Bristol (Downend) BS15 1SE | ||
31 | Bristol (Filton) BS34 7JU | ||
32 | Bristol (Newfoundland) BS2 9AP | ||
33 | Burntwood (UK Autocare) WS7 3TQ | ||
34 | Burton DE14 1SN | ||
35 | Bury St Edmunds IP33 1XP | ||
36 | Camberley GU15 3EJ | ||
37 | Camborne TR15 3PS | ||
38 | Cambridge (Clifton) CB1 7EA | ||
summary |
thank you in advance