Hi there!

I've got a large spreadsheet of captions to cartoons. The cells all begin with a single straight 'dumb' quote, and end the same way. I'd like to be able to replace them with double 'smart' quotes.

I'd normally do just a find and replace, except that I've also got contractions that obviously can't be double quotes.

Any idea on how best to do this?