Selection.Replace What and double quotes

  • Thread starter Thread starter Ed Peters
  • Start date Start date
E

Ed Peters

Hi all,

I need to replace double quotes " with nothing.

However the code below does not work for double quotes.

Selection.Replace What:=""", Replacement:=""

Any ideas?

Thanks,

Ed
 
Change your What value to this...

What:=""""

There are 4 quote marks after the equal sign.

Rick
 
Change your What value to this...

What:=""""

There are 4 quote marks after the equal sign.

Rick










- Show quoted text -
Click to expand...

Thanks but that does not work. I can replace any other character but
not "...
Ed
 
When I have problems with double quotes there is always one method that works

What:= chr(34) ' one quote
or
What:= chr(34) & chr(34) 'two quotes
or
What:= chr(34) & chr(34) & chr(34) 'three quotes
 
I need to replace double quotes " with nothing.
Thanks but that does not work. I can replace any other character but
not "...
Click to expand...

Did your line look like this...

Selection.Replace What:="""", Replacement:=""

....four quotes for the What and two quotes for the Replacement? When I tried
that line, it worked on my system.

Rick
 
Did your line look like this...

Selection.Replace What:="""", Replacement:=""

...four quotes for the What and two quotes for the Replacement? When I tried
that line, it worked on my system.

Rick- Hide quoted text -

- Show quoted text -
Click to expand...

Thanks sorted it now, I need all the other default options included in
the selection.replace for it to work.

Ta

Ed
 
Back
Top