以下是引用爱疯在2010-4-11 17:13:00的发言:
Sub TEST() Dim S As String Dim arr
S = [a1] '把A1的内容赋给字符串变量s If InStr(S, ".") Then '判断s是否包含"." arr = Split(S, ".") '将以"."作为分隔符的s,转为1维数组arr Else arr = Split(S, "-") '将以"-"作为分隔符的s,转为1维数组arr End If S = Join(arr, "-") '将1维数组arr,变回字符串 [b2] = "'" & Format(S, "yymmdd") '输出到B2单元格
End Sub [em04] 学习 |