Sub UID2CARD()
Dim A, i&, s$
A = Range("a1").CurrentRegion
For i = 2 To UBound(A)
s = A(i, 1)
s = Mid(s, 7, 2) & Mid(s, 4, 2) & Mid(s, 1, 2)
A(i, 2) = Application.WorksheetFunction.Hex2Dec(s)
Next i
[A1].Resize(i - 1, UBound(A, 2)) = A
End Sub
Function UID2CARD(x As Range) As Long
Dim s As String
s = VBA.Replace(x.Text, Chr(32), "")
s = Mid(s, 5, 2) & Mid(s, 3, 2) & Mid(s, 1, 2)
UID2CARD = Application.WorksheetFunction.Hex2Dec(s)
End Function