Eliminating the single quote generated

[mklalli]

I receive files from various sources that for some reason have a single
quote inserted before each cell's content except for numericals. Is
there a way to globally remove those?

 

[Frank Kabel]

Hi
try the following macro (processes the current selection):
sub remove_it()
dim rng as range
set rng=selection
with rng
.value=.value
end with
end sub

 

[icestationzbra]

check this link, see if this is what you want:

http://tinyurl.com/52pdb

it addresses a similar issue. use Frank Kabel's or Gord Dibben'
suggestion. i tested mine, and it does not seem to be working right no
(weird, it worked earlier)