vba中需要把“???.*.?”的单元格替换掉其中的"."为"/",然后更改单元格...答:For i = 1 To 18 a = Split(Cells(i, 1).Value, ".")(0)b = Split(Cells(i, 1).Value, ".")(1)c = Split(Cells(i, 1).Value, ".")(2)Cells(i, 3).Value = a & "/" & b & "/" & c Cells(i, 3).NumberFormatLocal = "yyyy/m/d;@"Next 希望能帮到你,for...
用vba 替换 单元格内的内容答:a列替换后的 Sub 按钮1_Click()Application.ScreenUpdating = False 'arr = Array("一", "二", "三", "四", "五", "六", "七", "八", "九", "十")For j = 0 To UBound(arr)Columns(1).Replace arr(j), j + 1 Next j Application.ScreenUpdating = True End Sub ...