7,763
社区成员
发帖
与我相关
我的任务
分享
Dim bResult() As Byte, sSource As String, i As Long, n As Long
Dim sResult As String
sSource = "A0012B2C56DE34H"
ReDim bResult(Len(sSource) - 1)
For i = 1 To Len(sSource)
If Mid(sSource, i, 1) <= "9" Then
n = n + 1
bResult(n - 1) = Asc(Mid(sSource, i, 1))
ElseIf i > 1 Then
If Mid(sSource, i - 1, 1) <= "9" Then
n = n + 1
bResult(n - 1) = 32
End If
End If
Next i
ReDim Preserve bResult(n - 1)
sResult = StrConv(bResult, vbUnicode)
MsgBox sResult