Replace double quotes ("") with single quote (") in VBA

[strorg]

I have a string varialbe that results in double quotes in several locations. At the end of several concatenations, I would like to replace the "" with ". Possible?

Regards...Tom

 

[Juan Pablo González]

Use Excel's SUBSTITUTE function, like this:<pre>theString = Chr(34) & Chr(34) & "Juan Pablo" & Chr(34)
?theString
""Juan Pablo"
?Application.Substitute(theString,Chr(34)&Chr(34),Chr(34))
"Juan Pablo"</pre>

 

[menol]

Re: Replace double quotes ("") with single quote (") in VBA

Use Excel's SUBSTITUTE function, like this:
theString = Chr(34) & Chr(34) & "Juan Pablo" & Chr(34)
?theString
""Juan Pablo"
?Application.Substitute(theString,Chr(34)&Chr(34),Chr(34))
"Juan Pablo"</pre>

I couldn't find the Substitute function so I tried to remove quotes using Replace function but did not work.

Then I realized some applications use a different ASCII code for quotation.

This forum post has a brief description to get this working .

Replace Function Doesn’t Replace Double Quotation in VBA « I Learnt Today…

Menol