Macro to look at certain parts of a cell and compare?

Hi,

Thanks for your help, but in this case I'm not sure that will work.
If I upload the sheet could you possibly have a look?

Thanks
Nick