Excel to get certain text from data

Originally Posted by xlnitwit

Hi,

Is VBA allowed for the solution? It will make returning multiple matches much simpler I believe. Also, are all the codes the same length as they appear to be in your example data?

Hi xlnitwit,

Would be great if there is such a macro which can do this. Would make my life easier but I'm not sure how to do so. :-(

Kind Regards,
Mark.