Convert ASCII to actual value

[Mgtrom]

I am reading a digital scale value into Excel but the value comes in as a series of symbols and not the numeric values displayed on the scale.

Something like: ]@@byd"@; etc.

From what I can tell this is some sort of ASCII format exported by the scale display. Is there a way to convert this to the numeric value

 

[dreid1011]

You can use =CODE(), but it seems it works only 1 character at a time.

 

[dreid1011]

However, you could do something like this:

=CODE(MID($A$2,COLUMNS($A$1:A1),1))

and drag it to the right across 9 columns. Or replace COLUMNS($A$1:A1) with ROWS($A$1:A1) and drag it down.

 

[FDibbins]

You can use =CODE(), but it seems it works only 1 character at a time.

Yes, you are correct, it only works on 1 character at a time perhaps use Text2Columns to break them out and "code" each cell- then combine them>