写一个Fucntion,我这里有一个,给你修改一下
Function ReplaceBadWord(InputS As String) As String
Dim jsqte As Integer, TempS As String
if trim(Inputs)="" then exit function For jsqte = 1 To Len(InputS)
If Mid(InputS, jsqte, 1)) <>" " Then
TempS = TempS + Mid(InputS, jsqte, 1)
End If
Next jsqte
ReplaceBadWord = TempS
End FunctionOk!
Function ReplaceBadWord(InputS As String) As String
Dim jsqte As Integer, TempS As String
if trim(Inputs)="" then exit function For jsqte = 1 To Len(InputS)
If Mid(InputS, jsqte, 1)) <>" " Then
TempS = TempS + Mid(InputS, jsqte, 1)
End If
Next jsqte
ReplaceBadWord = TempS
End FunctionOk!
如果"fff "后面的是VBnullstring 则trim无效,用
left("fff ",instr("fff ",VBnullstring))
AAAAA!!!!YourStr=Replace(YourStr,Space(1),VbNullString)为什么不能这样做呢?????我一直这样用!!!!!