Public Function F_FixChr(ByVal strChr As String, ByVal intLen As Integer) As String
Dim intChrLen As Integer
Dim strSpc As String
If IsNumeric(strChr) Then
intChrLen = Len(strChr)
strSpc = Space(intLen - intChrLen)
Else
intChrLen = LenB(StrConv(strChr, vbFromUnicode))
strSpc = Space(intLen * 2 - intChrLen)
End If
F_FixChr = strChr & strSpc & " "
End Function
用这个函数可以实现。
Dim intChrLen As Integer
Dim strSpc As String
If IsNumeric(strChr) Then
intChrLen = Len(strChr)
strSpc = Space(intLen - intChrLen)
Else
intChrLen = LenB(StrConv(strChr, vbFromUnicode))
strSpc = Space(intLen * 2 - intChrLen)
End If
F_FixChr = strChr & strSpc & " "
End Function
用这个函数可以实现。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货