试试这样,日期格式- Sub A()
- Dim m%, i%, strn$, rn As Range, rng As Range
- Application.ScreenUpdating = False
- m = [G65536].End(xlUp).Row
- Set rng = Range("g1:g" & m)
- For Each rn In rng
- For i = 1 To Len(rn)
- strn = Mid(rn, i, 1)
- If IsNumeric(strn) Then
- rn.Offset(0, 2) = DateSerial(Split(VBA.Split(Mid(rn, i), "月")(0), "年")(0), Split(VBA.Split(Mid(rn, i), "月")(0), "年")(1), 1)
- Exit For
- End If
- Next i
- Next rn
- Application.ScreenUpdating = True
- End Sub
复制代码 |