In an Excel spreadsheet I have 200,000 (two hundred thousand) Ordnance Survey
(UK) grid references in the format AB1234567890 (ie a 10-figure reference). I
need to reduce these to a two-figure reference (ie AB16). Is there a way of
doing this other than manually?