Eliminating the single quote generated

M

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

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
 
I

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)
 
Top