1、国防是国家为了防备和抵抗,制止,保卫国家主权、统一、领土完整和安全所进行的军事活动。(A)
20、中国人民解放军现役部队由陆军、海军、空军和(C)组成。
65、(D)有其鲜明的阶级性,不同的国家有不同的国防政策。
Function DelSpace(Rng As Range)
Dim Reg
Dim MyStr As String
Set Reg = CreateObject("vbscript.regexp")
With Reg
.Pattern = "[A-Z](?=))"
.Global = True
MyStr = Reg.Replace(Rng, " ")
End With
DelSpace = MyStr
End Function
我是想提取括号里面的字母。但是现在结果是:1、国防是国家为了防备和抵抗,制止,保卫国家主权、统一、领土完整和安全所进行的军事活动。( )
怎么才能提取字母呢!谢谢!
Function DelSpace(str As String) As String
With CreateObject("vbscript.regexp")
.Pattern = "[A-Z](?=))"
.Global = True
DelSpace = IIf(.Execute(str).Count, .Execute(str)(0), "")
End With
End Function
Function DelSpace(str As String) As String
With CreateObject("vbscript.regexp")
.Pattern = "[A-Z](?=))"
.Global = True
DelSpace = IIf(.Execute(str).Count, .Execute(str)(0), "")
End With
End Function
Function DelSpace(str As String) As String
With CreateObject("vbscript.regexp")
.Pattern = "[A-Z]+(?=))"
.Global = True
DelSpace = IIf(.Execute(str).Count, .Execute(str)(0), "")
End With
End Function