View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Seperate Text and numbers in Post code

It is "B", as in B15 3SX (where I used to live).

Pete

On Apr 7, 7:25*pm, pdberger
wrote:
Chriso --

What does Birmingham's code look like?



"chriso" wrote:
Hi
I have a data sheet and need to get just the area from a post code e.g BS1
1JN I need just the BS in a column. *I would use left,2 etc but problem is
some codes such as Birmingham only have 1 letter.


Any ideas please.
Thanks
Chris- Hide quoted text -


- Show quoted text -