Decimal To Ascii In Excel

SteveR Rambin · Jul 3, 2013

If there are any Excel guys there that know how to convert a decimal value from ControlLogix to Ascii in Excel I sure would appreciate it.

MartB · Jul 3, 2013

I think you can use =CHAR(x)
where x is the number or cell you want to convert to an ASCII character

Mike_RH · Jul 3, 2013

How about the TEXT function?

=TEXT(A3,"0.000")

SteveR Rambin · Jul 3, 2013

Yes I tried the Char and got only an error "Value"

SteveR Rambin · Jul 3, 2013

Looking at the Text function but do not see a characture for Ascii

MartB · Jul 3, 2013

Hmmm I'm not sure then, because I just tried =CHAR(B1) in cell A1 and it returned exactly what I was expecting when I typed a number in B1

SteveR Rambin · Jul 3, 2013

Let me be a little more clear. I'm getting a number in decimal from CLX that represents an Ascii text. When you change the data style in the monitor tag you can see the Ascii. Ex, 17323 is CO in Ascii. Can this be done in Excel?

Mike_RH · Jul 3, 2013

Steve,

=Text( ) will convert a number e.g. 65 to the text 65
=Char( ) will convert a number to its ASCII character code e.g. 65 becomes A

Perhaps a bit more detail as to what you want to accomplish?

SteveR Rambin · Jul 3, 2013

Yes Here's what I posted on Microsoft TechNet

I have created a spread sheet to track paper rolls as they move down the wharehouse. I am getting data from a ControlLogix processor via RSLinx and Topic Configuration. The problem is that I can display the roll order number in 5 cells as decimal numbers from the CLX but it represents an Ascii code.
Ex. Roll # CO 3G 03 06 3A is displayed in excel as 17200 13127 12339 12342 13121. Is there a formula function that can convert the decimal #'s so I can see the actual roll number in Ascii?

Mike_RH · Jul 3, 2013

What is the tag type / structure in ControlLogix?

SteveR Rambin · Jul 3, 2013

It's an Interger data type array of 1000 words

Mike_RH · Jul 3, 2013

Since the data is ASCII, is there a reason you are not using a String data type?

SteveR Rambin · Jul 3, 2013

It's what the guy that programmed it used. I'm a troubleshooter trying to figure out where the data for the rolls are getting screwed up. The Exces spreadsheet I made has helped me find 6 errors in the code so far.

Mike_RH · Jul 3, 2013

OK, How about this:
=CONCATENATE(CHAR(HEX2DEC(LEFT(DEC2HEX(B5),2))),CHAR(HEX2DEC(MID(DEC2HEX(B5),3,2))))

There is probably an easier method.

This will need some more logic if the number does not represent two ASCII characters.

Good luck.

SteveR Rambin · Jul 3, 2013

Woah! You have really been working hard on this one. I'll plug it in right now.

Decimal To Ascii In Excel

SteveR Rambin

Member

MartB

Lifetime Supporting Member

Mike_RH

Lifetime Supporting Member

SteveR Rambin

Member

SteveR Rambin

Member

MartB

Lifetime Supporting Member

SteveR Rambin

Member

Mike_RH

Lifetime Supporting Member

SteveR Rambin

Member

Mike_RH

Lifetime Supporting Member

SteveR Rambin

Member

Mike_RH

Lifetime Supporting Member

SteveR Rambin

Member

Mike_RH

Lifetime Supporting Member

SteveR Rambin

Member

Similar Topics