wildswing
Member
Do any of you Excel gurus know of a VB code or function that will convert ASCII text into it's decimal equivalent? I'm not VB savy at all.
I need something that will do this...
A ---> 65
B ---> 66
C ---> 67
What I'm eventually trying to achieve is a spreadsheet in which I enter ASCII text string and have it return the equivalent decimal values like this...
Text entered (thinking one character per cell - 20 characters max)...
3/8 X 8 SUP
Returned decimal equivalents would be...
51 47 56 32 88 32 56 32 83 85 80
I can take it from there, converting to binary, combining into 16 bit integers for use in selecting recipes in an oem apps database.
Any advice or assistance you can provide would be very much appreciated. Thanks in advance!
I need something that will do this...
A ---> 65
B ---> 66
C ---> 67
What I'm eventually trying to achieve is a spreadsheet in which I enter ASCII text string and have it return the equivalent decimal values like this...
Text entered (thinking one character per cell - 20 characters max)...
3/8 X 8 SUP
Returned decimal equivalents would be...
51 47 56 32 88 32 56 32 83 85 80
I can take it from there, converting to binary, combining into 16 bit integers for use in selecting recipes in an oem apps database.
Any advice or assistance you can provide would be very much appreciated. Thanks in advance!
Last edited: