Mano,

Use an extra column, where you create duplicates for the quoted values.
The simplest such formula is

=A1

Then Copy the new column and using Edit|Paste Special...|Values, paste
it over the original data. This will overwrite the single quote.

Elpizw na boithaei

Kostis Vezerides