Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I've got some problems in converting Hexadecimal values to ASCII
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
I've got some problems in converting Hexadecimal values to ASCII
What are you trying to do here, convert what to what? An example would be
useful. -- HTH Bob Phillips (remove nothere from email address if mailing direct) wrote in message oups.com... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |