single quote removal

  • Thread starter Thread starter Serge
  • Start date Start date
S

Serge

Hi everyone,

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.

Thank you,

S
 
Thank you!
It worked!

Question:
It works on a selected columns range only.
How do I make it to work on every table you open and to
automate this, like a trigger. Also to remove the single
quote from all values in a table at once, without
selecting the table range first. I am novice in VBA. Pls
help.
Pls ask questions, if something is not clear.

Thx
 
Back
Top