高手帮我

[lianjizhi]

我想请问一下,哪位高手能否告诉我用len(s)如何去掉字符串中的空格,而得到精确的数字

[WWolf]

if isnumeric(trim(s)) then num1=cint(s) 'num1=clng(s) 'num1=csng(s)

[foolishtiger]

Dim strTest as String
Dim strS as String

strTest=Replace(strS," ","")
Msgbox "去掉所有空格后的长度是:" & Len(strTest)