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


"Ed Peters" wrote in message
oups.com...
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

On 13 Sep, 07:26, "Rick Rothstein \(MVP - VB\)"
wrote:
Change your What value to this...

What:=""""

There are 4 quote marks after the equal sign.

Rick

"Ed Peters" wrote in message

oups.com...



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- Hide quoted text -

- Show quoted text -

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

"Ed Peters" wrote:

On 13 Sep, 07:26, "Rick Rothstein \(MVP - VB\)"
wrote:
Change your What value to this...

What:=""""

There are 4 quote marks after the equal sign.

Rick

"Ed Peters" wrote in message

oups.com...



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- Hide quoted text -

- Show quoted text -

Thanks but that does not work. I can replace any other character but
not "...
Ed

I need to replace double quotes " with nothing.

However the code below does not work for double quotes.

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

Any ideas?

Change your What value to this...

What:=""""

There are 4 quote marks after the equal sign.

Thanks but that does not work. I can replace any other character but
not "...

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

On Sep 13, 9:39 am, "Rick Rothstein \(MVP - VB\)"
wrote:
I need to replace double quotes " with nothing.

However the code below does not work for double quotes.

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

Any ideas?

Change your What value to this...

What:=""""

There are 4 quote marks after the equal sign.

Thanks but that does not work. I can replace any other character but
not "...

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 -

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

Ta

Ed