I have a spreadsheet with a UK postcodes column in it...
I have another spreadsheet that looks like this...
I want to be able to match the 2 together based on the first 1 or 2 letters in the postcode so i can then filter my data by Post Town or Region.
How can i obtain the first 1 or 2 letters from my list of full postcodes?
I am thinking i will need to check for an ASCII number to determine if i need just the first letter or the first 2 but i am sure there is a better alternative!? PurgeChar looks interesting, perhaps i can use subfield to grab the first part of the postcode and purgechar to remove the number part(s) - (thinking as i'm writing here).
Any ideas? Is there a better solution?