how do I have to script if I want to replace a: "

**dschmitt** · 07-14-2014, 03:57 AM

In the script below I am replacing ; with a space.
How does the script look like if I want to replace a " instead of the ;

        
Sheets("temp sheet").Cells(z, 1).Value = _
Application.WorksheetFunction.Substitute(Sheets("temp sheet").Cells(z, 1).Value, ";", " ")

**romperstomper** · 07-14-2014, 03:59 AM

You don't really need Substitute there:

Sheets("temp sheet").Cells(z, 1).Value = Replace(Sheets("temp sheet").Cells(z, 1).Value, """", " ")

**dschmitt** · 07-14-2014, 04:22 AM

I see. I got both to working. Thanks

Re: how do I have to script if I want to replace a: "