1
=CHAR(86)
or
=CHAR(A1)
with 86 in cell A1
2+3
You'd need a macro for that I think.
--
HTH. Best wishes Harald
Followup to newsgroup only please

"Syrus the Virus " skrev i
melding ...
Hi guys and galls,

Question 1:

I know how to read what kind of ASCII is standing in a cell ( Example:
6 is 54 and z is 90) but what if I want it the other way around,
displaying the leter with the code 86 for example.

Question 2:

And what if I want to read a multiple filled cell. A cell with for
example VW as Value?

Question 3:

Can I rip the contens of the cell apart and check if the Carathers used
in a cell are for example letters ( like ASCII between 65 and 90)

Please

help!!!!.1.!!!!!!!1!1.11.1!1!.1111.1!!!!!! 1.!!111!.....1.1.!!
!!1.111!!!!!!


---
Message posted from http://www.ExcelForum.com/