I have a .csv document in Microsoft excel that I import into Drupal that gets data pasted into it from Word. But when I try to import it, I usually get errors due to curly quotes, dashes, hyphens and all the other fancy styles that Word likes to put in its documents and that ends up getting copied over into the.csv file. So what I end up doing is manually find/replace these items one by one until I get no more errors.
I'd like to speed up this manual process so is there a formula I could run in excel that would convert the 'fancy' characters back into their standard ones so that my database could import them properly?
Pretty much I need the following to happen:
"‘" = "'" "’" = "'" "”" = '"' "“" = '"' "–" = "-" "—" = "-"