Thanks for that oeldere, it seems to work very well. I did use the text to column function to extract the data in columns I:P.

Is there a way to do this without using VBA though, the people who will eventually use this document are better with formulas than coding?

Thanks once again.