UDF?
Function HexCode(sInp As String) As String Dim i As Long For i = 1 To Len(sInp) HexCode = HexCode & Right("0" & Hex(Asc(Mid(sInp, i, 1))), 2) Next i End Function
A B C 1ALL 414C4C B1: =hexcode(A1) 2About 41626F7574 3BOOT 424F4F54
Sort by col B.
Bookmarks