Excel to get certain text from data

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?

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.