Need an Excel guru's help converting ASCII to Decimal

wildswing

Member
Join Date
May 2005
Location
Sault Ste Marie, Ontario
Posts
281
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!
 
Last edited:
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.
 
Last edited:

Similar Topics

Hi... I m working with delta PLC. I can interfacing between Delta Software and Intouch Sw. Now I have to export the data(sensors values) of delta...
Replies
1
Views
3,328
I need help with trying to expand a program that takes pressure and position from a ram follower machine and puts it into excel. The excel sheet...
Replies
34
Views
6,120
Hello, I had a previous post regarding Excel and RSlinx not updating automatically. I am running Excel 2007 and Linx Classic on my PC. I have...
Replies
11
Views
6,034
We are trying to poll data coming from a PLC for remote monitoring we have the IP address of the PLC and the default port number and the path is...
Replies
25
Views
423
The idea here is to provide for a brief rapid influx of message codes while preventing sequentially repeating the same message. i.e. if two...
Replies
23
Views
536
Back
Top Bottom