Hi, all.

I have an Excel question that I hope someone knows the answer to...

I have a cell with a value and in another cell I would like to have the ASCII representation of the first value. I tried using Char(), but it seems it will only deal with direct numbers, not cells. Anyone know how to do this? I'm using Excel 2003.

Edit: Seems like, after some more testing, that it does in fact work also with cells...

Stig

The simple solution is to copy the source cell and then (right-click) Paste Special -> Values into the destination cell(s). Alternatively, using the =value() inbuilt function may do what you need.

If neither of these are the solution you're looking for then it might help to have a bit more info on what you're looking to achieve.

I managed to do what I wanted when I also used the HEX2DEC function as well (the values are hex values), but thanks for the suggestion. The formula I ended up with looks like this: =IF(HEX2DEC(D2)>25;IF(HEX2DEC(D2)<127;CHAR(HEX2DEC(D2));"");"")
Not pretty, but it works...

Stig