Unoffical empeg BBS

Quick Links: Empeg FAQ | RioCar.Org | Hijack | BigDisk Builder | jEmplode | emphatic
Repairs: Repairs

Topic Options
#291797 - 28/12/2006 12:41 Another Excel question
StigOE
addict

Registered: 27/10/2002
Posts: 568
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


Edited by StigOE (28/12/2006 13:10)

Top
#291798 - 28/12/2006 23:30 Re: Another Excel question [Re: StigOE]
AndrewT
old hand

Registered: 16/02/2002
Posts: 867
Loc: Oxford, UK
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.

Top
#291799 - 29/12/2006 06:06 Re: Another Excel question [Re: AndrewT]
StigOE
addict

Registered: 27/10/2002
Posts: 568
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

Top