Remove single quote, help needed!
 

Hi everyone,

I have a problem with single quote in front of a value
wthat was exported from Access and viewed in Excel. Does
anyone you know how to remove a single quote? I have tried
some of Excel build-in functions but it does not help...

Millions of thanks!

Sergei

Remove single quote, help needed!
 

ActiveCell.Formula = ActiveCell.Value

should remove it.

--
Regards,
Tom Ogilvy


"Sergei" wrote in message
...
Hi everyone,

I have a problem with single quote in front of a value
wthat was exported from Access and viewed in Excel. Does
anyone you know how to remove a single quote? I have tried
some of Excel build-in functions but it does not help...

Millions of thanks!

Sergei