Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Extract Postal Area from UK Postcode

Hi all   For a long time I have been using an Excel formula to convert the first half of a UK postcode into its respective postal area code. For example, NE34 become NE.   It looks like this, whe...
  • jthomson's avatar
    jthomson
    8 years ago

    I'd look to do this in a couple of steps - first grab the first two characters using LEFT([yourpostcodefieldname],2), then I'd look to handle the cases where your postcode just has the one letter afterwards - not sure on the best way to do that given there's ten options you want to look for and then remove

     

    edit - searched a bit and this has been asked previously, try having a look at https://community.powerbi.com/t5/Desktop/UK-Post-Codes/td-p/247470

jthomson's avatar
jthomson
Icon for Solution Sage rankSolution Sage
8 years ago

I'd look to do this in a couple of steps - first grab the first two characters using LEFT([yourpostcodefieldname],2), then I'd look to handle the cases where your postcode just has the one letter afterwards - not sure on the best way to do that given there's ten options you want to look for and then remove

 

edit - searched a bit and this has been asked previously, try having a look at https://community.powerbi.com/t5/Desktop/UK-Post-Codes/td-p/247470