Hi

Type Ctrl+A to select the whole sheet.
Ctrl+H to bring up Find and Replace
Find '
Replace (leave blank)
Replace All

Beware, that if any numbers are greater than 15 digits, then all numbers
after the 15th digit will be replaced by 0's

--
Regards

Roger Govier


"Avadivelan TCS" wrote in
message ...
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