Extra Characters When Pasting From MS Access

  • Thread starter Bob_The_Borg \(removethis\)
  • Start date
B

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?
 
F

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
 
G

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



.
Click to expand...
 
Top