I am trying to write a UDF to extract the first characters and the first character of end part of a UK postcode (If supplied).
Examples of the various postcodes I recieve - L1 1HY, L12 1HY, LN12 1HY, L11HY, L121HY, LN121HY, L1, L12, LN12 ETC
I have started writing the below but am struggling...