Thanks for the help John.

That's exactly what I need it to do but it has to be able to pick the demonym out of the rest of the text in the cell. Do you think its possible?

Thanks

Pete