Seth, you are a life saver.

Many thanks that works a treat.

:smooooth::-D:-D:smooooth:

The values are not set to a standard so will change from CR to LM or TR or ?? and will not always be followed by a numeric so could...

Thanks for that, but not quite what I was after.

I need the output to also be comma seperated but with the name value from a seperate table

Let me try...