用vba无论多少字一点不错
Sub aa()
rw = Sheet1.Cells(Rows.Count, 1).End(3).Row
ar = Sheet1.Range("a2:a" & rw)
a = "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ"
For i = 1 To UBound(ar)
t = "": z = 0: q = 0
For j = Len(ar(i, 1)) To 1 Step -1
b = Mid(ar(i, 1), j, 1)
c = InStr(a, b)
If c <> 0 Then
z = j
Exit For
End If
Next
For k = z - 1 To 1 Step -1
b = Mid(ar(i, 1), k, 1)
c = InStr(a, b)
If c = 0 Then
q = k + 1
Exit For
End If
Next
If z > 0 And q > 0 Then ar(i, 1) = Mid(ar(i, 1), q, z - q + 1) Else ar(i, 1) = ""
Next
Sheet1.Range("c2").Resize(UBound(ar), 1) = ar
End Sub |