In case it's relevant this is my sub procedure:
Public Sub symrem(nw)
Do
nwold = nw
nw = Replace(nw, ".", "") 'takes out periods
nw = Replace(nw, ",", "") 'takes out commas
nw = Replace(nw, ",", "")
For i = 33 To 64 'takes out all non-letter characters
nw = Replace(nw, Chr$(i), "")
Next i
For i = 91 To 96
nw = Replace(nw, Chr$(i), "") 'takes out all non-letter characters
Next i
For i = 123 To 155
nw = Replace(nw, Chr$(i), "") 'takes out all non-letter characters
Next i
If nwold = nw Then
Exit Do
End If
Loop
End Sub
|