Need an Excel guru's help converting ASCII to Decimal

[wildswing]

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!

 

[Bob O]

I searched and maybe this will get you going.
=CODE(A1)
Type this into a cell and then place your ASCII value in cell A1.

Time for yard work.

 

[Steve Bailey]

In Excel:

CHAR(65) = A
CODE("A") = 65

In your example:
CODE(MID("3/8X8SUP",1,1)) = 51
CODE(MID("3/8X8SUP",2,1)) = 47
CODE(MID("3/8X8SUP",3,1)) = 56
etc

 

[wildswing]

Thanks guys!

Here's what I did. I entered the text string in cell A1. Across row 2, I copied the following function:

=CODE(MID($A1,COLUMN(),1))