Hi All,
Excel 2007
I'm looking to extract parts of an address into different columns, I've already extract the Country, Post Code & Town. But what i'm having trouble doing is extract the street address and county, the reason I'm having trouble is because not every address has a county.
Below is what I have so far:
I need to extract Street (which is in red) into the Street Column
County (which is highthlighted in dark blue) into county
Excel 2010
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
<tbody>
</tbody>
Thanks in advance for our help
Excel 2007
I'm looking to extract parts of an address into different columns, I've already extract the Country, Post Code & Town. But what i'm having trouble doing is extract the street address and county, the reason I'm having trouble is because not every address has a county.
Below is what I have so far:
I need to extract Street (which is in red) into the Street Column
County (which is highthlighted in dark blue) into county
Excel 2010
A | B | C | D | E | F | |
---|---|---|---|---|---|---|
1 | Address1 | Street | County | Town | Post Code | Country |
2 | 123 Bridge Street Kent KA4 1AA UNITED KINGDOM | Kent | KA4 1AA | UNITED KINGDOM | ||
3 | Bridge Street Kent KA4 1AA UNITED KINGDOM | Kent | KA4 1AA | UNITED KINGDOM | ||
4 | 1 Random Road Edinburgh EH12 9AA UNITED KINGDOM | Edinburgh | EH12 9AA | UNITED KINGDOM | ||
5 | East Avenue Maidstone Kent K1 1AA UNITED KINGDOM | Kent | K1 1AA | UNITED KINGDOM | ||
6 | 19 Random London S1 1AA UNITED KINGDOM | London | S1 1AA | UNITED KINGDOM | ||
7 | 178 East Wellingotn St Mid-Lothian Edinburgh EH1 1AA UNITED KINGDOM | Edinburgh | EH1 1AA | UNITED KINGDOM |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1
Worksheet Formulas
<thead> </thead><tbody> </tbody> |
<tbody>
</tbody>
Thanks in advance for our help