View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Avadivelan TCS Avadivelan TCS is offline
external usenet poster
 
Posts: 19
Default Remove single quote

Does anyone know how to escape(remove)single quote to
appear before a values, when a report is exported from
Access to Excel. I tried to use "replace", "clean"
or "right" functions but it does not help.
I am having more than 3600 columns like that:
€˜394,3568,789
'7896,456,1234
Can you suggest a macro for this

Thanks in advance for your reply