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, ";", " ")