UK Postcode mapping MS Excel

[rav00_uk]

Hi,

I am trying to plot UK postcodes on a map in Excel (2000) using the MS
Map function. When I select the list of postcodes as the data i get the
following error message: "You must include a column of geographic data
in your data". As far as I am aware Postcodes are geographic data, so
why does this error occur?

Could it be because I am selecting the whole Postcode instead of the
first 2 letters. If so, how can I select the first 2 letters without
going through the whole list and deleting individual characters from
each postcode manually?

Many Thanks for your help

Ravi.

 

[Nick Hodge]

Ravi

I suspect it will only work on Post Code Areas (126) although I don't have
2000 to test. To separate off the area (1st letter in codes like L
(Liverpool), G (Glasgow) or two letters in most), use the following formula
This can start in A1 and be copied down)

=IF(ISNUMBER(VALUE(MID(A1,2,1))),LEFT(A1,1),LEFT(A1,2))

I would also look to invest in MapPoint as this is far better, links with
all Office programs and allows you to use complete post codes or any part of

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)