Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
make that "parse" :-|
What are the double-byte equivalents of these ascii functions? --- I created the following function to do this conversion by pulling out one character at a time from the string and doing an operation on that character to get the ascii equivalent. Function HEXEDASCII(asciiString As String) As String Const COMMA As String = "," Dim i As Long Dim sOut As String For i = 1 To Len(asciiString) If ((i - 1) Mod 8 = 0) Then sOut = sOut & vbCrLf & " " sOut = sOut & "0x" & _ Right("0000" & Hex(Asc(Mid(asciiString, i, 1))), 4) _ & COMMA & " " Next i HEXEDASCII = sOut & "0" & vbCrLf End Function |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
find and replace numeric strings in larger text strings | Excel Worksheet Functions | |||
Download SAP japanese/korean tables to EXCEL | Excel Discussion (Misc queries) | |||
Can excel support english and korean text in the same spread shee. | Excel Discussion (Misc queries) | |||
Prompt for Korean proofread | Excel Discussion (Misc queries) | |||
How do I pars in excel | Excel Discussion (Misc queries) |