Northern ireland postcodes 1

[SQLScholar]

Hey,

Excel problem -

One thing that would make my life easier is if i had a peice of code that would look through a list of addresses and if the postcode colomn has a PC begining with BT then in another colomn write "northern Ireland". If it doesnt then write "United Kingdom".

Also how would i make this available from any new document i made!

TIA

Dan ----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!

 

[xlhelp]

Which kind do you have? Prototype or Obsolete?

Anyway, will this work for you?
=if(left(cell_ref,2)="BT", "Northern Ireland","United Kingdom&quot

 

[SQLScholar]

obsolete, cause prototypes probably dont work very well cause of all the bugs.... then when they have sorted them, there released and then obsolete.

Thanx for the code mate.... cheers STAR
----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!