7,789
社区成员
发帖
与我相关
我的任务
分享
For i = 0 To 32
s = Replace(s, Chr(i), "")
Next
Private Sub Command1_Click()
Dim s As String
s = "你想要的字符" & vbLf + vbCr
Debug.Print Len(s)
s = RemoveSomeChar(s)
Debug.Print Len(s)
End Sub
Private Function RemoveSomeChar(ByVal s As String) As String
Do Until Right(s, 1) <> vbLf And Right(s, 1) <> vbCr
s = Left(s, Len(s) - 1)
Loop
RemoveSomeChar = s
End Function