I have a database that is currently in excel 2013 but I will need this 'facility' in Access too.
A cell will contain a string that 'may' be just a postcode or it may be a region, followed by a postcode.
Liverpool, L6 4RT
London, SW1P 6YU
FY3 6TF, England
I need to be able to extract the postcode out of that (preferably without the space). The postcode can be in any of the following formats
LN NLL, LNN NLL, LLN NLL, LLNN NLL, LLNL NLL
where L is a capital letter and N is an integer. If it helps, the last block of 3 characters is always Number, Letter, Letter and that format is never used in the first half.