View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Manos
 
Posts: n/a
Default Delete quota from a cell

Thank you Kostas


"vezerid" wrote in message
ups.com...
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