Forum Discussion
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...
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
Hi I've been trying to use this as per the comments but everytime i enter this expression it gives me various error codes? Brand new to this so apologies if I'm doing somehting silly. Any help you can share would be greatly appreciated, thanks.