Adding a field for county in a table of address info "Michael Morin" <mpmorin[ at ]verizon.net> 12/29/2008 7:46:09 PM I want to add a county column in a table with address information. I have a list of towns for each county but I am not sure how to best indicate which county that town is included in. I have a list of 700 or so addresses so I don't have time to just type in county info for each address.

Re: Adding a field for county in a table of address info "Bernard Liengme" <bliengme[ at ]stfx.TRUENORTH.ca> 12/29/2008 7:55:46 PM You could use a lookup table but, as this seems to be a one-time project, the work making the table might be more than just typing. Remember that once you have a county in your new column you will not need to type its name every time as Excel auto-complete feature should take over. I think I would be tempted to sort by town - it might save some 'thinking' time. best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Michael Morin" <mpmorin[ at ]verizon.net> wrote in message news:84B4C686-711B-43D1-A134-C163878EEF45[ at ]microsoft.com... [Quoted Text] >I want to add a county column in a table with address information. I have >a list of towns for each county but I am not sure how to best indicate >which county that town is included in. I have a list of 700 or so >addresses so I don't have time to just type in county info for each >address.

Re: Adding a field for county in a table of address info "Bill Ridgeway" <info[ at ]1001solutions.co.uk> 12/29/2008 10:02:06 PM "Michael Morin" <mpmorin[ at ]verizon.net> wrote in message news:84B4C686-711B-43D1-A134-C163878EEF45[ at ]microsoft.com... [Quoted Text] >I want to add a county column in a table with address information. I have >a list of towns for each county but I am not sure how to best indicate >which county that town is included in. I have a list of 700 or so >addresses so I don't have time to just type in county info for each >address. The Royal mail requirement for a County name to be included in (many but not all) address went some years ago. Counties (as I and many people knew them) disappeared in 1974 (England & Wales) and 1975 (Scotland). Since then counties have been created in England and practically the whole of Scotland and Wales and some have since disappeared (e.g. Avon) and Unitary Authorities have appeared. If the Royal Mail doesn't require counties included in the address I would suggest you save yourself the bother. I think the only exception would be if you don't have a PostCode for a Post Town name which is duplicated (e.g. Newport) - but finding PostCodes should be very easy. If you really have to add counties the only way is to go to the pre 1974 when it was 'stable' as since then there is a mish-mash of old counties, new names, changed names and changed borders to contend with. Bill Ridgeway

Re: Adding a field for county in a table of address info "Michael Morin" <mpmorin[ at ]verizon.net> 12/30/2008 4:37:30 PM I have already received a table in an XLSX file. It is already set up. The reason why I want to add a county column is to be able to crunch numbers of how many people live in which counties, etc. "Bernard Liengme" <bliengme[ at ]stfx.TRUENORTH.ca> wrote in message news:OIF9x9eaJHA.3692[ at ]TK2MSFTNGP04.phx.gbl... [Quoted Text] > You could use a lookup table but, as this seems to be a one-time project, > the work making the table might be more than just typing. Remember that > once you have a county in your new column you will not need to type its > name every time as Excel auto-complete feature should take over. I think I > would be tempted to sort by town - it might save some 'thinking' time. > best wishes > -- > Bernard V Liengme > Microsoft Excel MVP > http://people.stfx.ca/bliengme > remove caps from email > > "Michael Morin" <mpmorin[ at ]verizon.net> wrote in message > news:84B4C686-711B-43D1-A134-C163878EEF45[ at ]microsoft.com... >>I want to add a county column in a table with address information. I have >>a list of towns for each county but I am not sure how to best indicate >>which county that town is included in. I have a list of 700 or so >>addresses so I don't have time to just type in county info for each >>address. > >

Re: Adding a field for county in a table of address info "Michael Morin" <mpmorin[ at ]verizon.net> 12/30/2008 4:39:57 PM In the U.S., we still have counties and it is involved in state government. "Bill Ridgeway" <info[ at ]1001solutions.co.uk> wrote in message news:%232VRSEgaJHA.5788[ at ]TK2MSFTNGP03.phx.gbl... [Quoted Text] > "Michael Morin" <mpmorin[ at ]verizon.net> wrote in message > news:84B4C686-711B-43D1-A134-C163878EEF45[ at ]microsoft.com... >>I want to add a county column in a table with address information. I have >>a list of towns for each county but I am not sure how to best indicate >>which county that town is included in. I have a list of 700 or so >>addresses so I don't have time to just type in county info for each >>address. > > The Royal mail requirement for a County name to be included in (many but > not all) address went some years ago. Counties (as I and many people knew > them) disappeared in 1974 (England & Wales) and 1975 (Scotland). Since > then counties have been created in England and practically the whole of > Scotland and Wales and some have since disappeared (e.g. Avon) and Unitary > Authorities have appeared. If the Royal Mail doesn't require counties > included in the address I would suggest you save yourself the bother. I > think the only exception would be if you don't have a PostCode for a Post > Town name which is duplicated (e.g. Newport) - but finding PostCodes > should be very easy. > > If you really have to add counties the only way is to go to the pre 1974 > when it was 'stable' as since then there is a mish-mash of old counties, > new names, changed names and changed borders to contend with. > > Bill Ridgeway >