What a cow of a problem!

I can't change the data and add an extra apostrophe.

Thanks for the link, sure is a mess and ticking the
Transition box didn't help.

I'll try changing every ' to a substitute character then
change that back when it's out of Excel. I was only using Excel for
ease of editing.

I can't quite believe Excel would eat a character and stuff you up
like this!

Thanks - Kirk