Extra Characters When Pasting From MS Access

[Bob_The_Borg \(removethis\)]

Has anyone encountered extra characters in an Excel sheet
after pasting from MS Access?

We're getting a single quote character (') to the left of
every piece of data in every field when we paste a table
from MS Access 2K to MS Excel 2K. It's only visible in
the bar at the top when you click on the cell. And I
tried a find and replace but it cannot find it. Wierd!


Any idears?

 

[Frank Kabel]

Hi
try the following macro to remove these apostrophes:
sub remove_it()
dim rng as range
set rng = selection
rng.value=rng.value
end sub

 

[Guest]

Thanks Frank, I'll give it a try.

-----Original Message-----
Hi
try the following macro to remove these apostrophes:
sub remove_it()
dim rng as range
set rng = selection
rng.value=rng.value
end sub

--
Regards
Frank Kabel
Frankfurt, Germany



.