Find codes form Sheet 2 in Text in cells in Column A in Sheet 1

Hi,

What I am trying to do is to find if any cells (which contains a large amount of text) in ‘Column A’ on Sheet 1 contain any codes that resemble the standard format for codes e.g. RMG123456, RMG4567 and if so display them in ‘Colum B’, ‘Colum C’, ‘Colum D’ etc. as any cell in ‘Column A’ may contain no codes or one or more codes.



Please see attached spreadsheet

Any assistance would be greatly appreciated


Many thanks in advance


Regards Rob

N.B. Excel version 2003