You can use the Chr function to get the character corresponding
to an Ascii value. For example, Chr(65) will return an 'A'
character as a string.

You can loop through the characters in a string, ensuring that
each character is an uppercase letter. E.g.,

Dim S As String
Dim C As String
Dim N As Long

S = Range("A1").Text
For N = 1 To Len(S)
C = Mid(S, N, 1)
If Asc(C) = 65 And Asc(C) <= 90 Then
' upper case character
Else
' not an upper case character
End If
Next N


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Syrus the Virus "
wrote in message
...
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/