Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi there, i've got some problems converting hexadecimal value to ascii.
This is how my coding looks like. Function ReturnHEX(TheString as String) As String Dim i As Integer, RtnStr As String RtnStr = "" For i=1 To Len(TheString) RtnStr=RtnStr &Right$("&H" & Str(CInt(Mid$(TheString,i,1))),2) & " " Next ReturnHEX=RtnStr End Function Hope someone can come out a solution for this. Thanks. Regards, vleong |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Import hexadecimal data into excel keeping hexadecimal format | Excel Discussion (Misc queries) | |||
Converting ASCII Into Excel, any Ideas? | Excel Discussion (Misc queries) | |||
Formula for converting Binary to Hexadecimal | New Users to Excel | |||
converting ascii csv to .txt for financial data | Excel Discussion (Misc queries) | |||
Converting hex to ascii | Excel Programming |