We have just started using Sage 50 Canadian Premium and are implementing a new database for inventory. 

The problem is that almost all inventory descriptions contain either an inches (" quotation mark) or feet (' apostrophe mark ) sign. I can get rid of the extra inches mark from importing within Excel with just a replace function but when I go to import I end up with a double inch mark.

Example:

How it should look - Oak Dowel 2" x 4' - Natural Finish

How it imports back in: Oak Dowel 2"" x 4' - Natural Finish

We have approximately 50000 items so not manually going in to change them.

I'm sure we're not only one who has experienced this but Sage advisors couldn't really help.  

Thanks in advance for any suggestions,

Chris