geographical regions

hi

i have a spreadsheet with user contacts in with a list of postcodes and want to split the postcodes into 6 regions

so does anyone have any idea how i would go about doing this

i want the regions to be
London
Scotland
Midlands
Wales
North
South east

what i thought i would be able to do was to use vb to look at the first 2 characters in each cell in the postcode colomn and then depending on the first two characters place it in the respected region

but i dont know how to go about coding this as i have not really used vb before.

any help appreciated

regards
chris