Hi,

I can't help thinking that a simple Excel formula would be the best option, even if this is used by a macro to populate a column of results. It's always, always better - and quicker to use standard Excel functions where possible rather than resorting to VBA.

Upload an example workbook containing all permutations of the post codes you're interested in and I'm sure a fairly simple string slicing function will be the answer.

Regards