What hides between Shadow and Light?

**Bloody_Eugene** · 08-17-2009, 07:50 PM

(08-17-2009, 07:27 PM)mmammel Wrote: Looks good. A simple function to convert letters to numbers is:
if a letter is in cell A1 for example
=CODE(A1)
will give the ASCII value of the letter. If its a capital letter, just subtract 65 to get a range of 0-25
to get back to a letter from a number
=CHAR(B1+65)
if B1 contains a number 0-25
the mod function is:
=MOD(B3,26)
for mod 26.

Thank you! If only I had known! Tongue

:
Ok, but now I'm not doing the stuff all again...It was my first excel project, and it was quite hard to made... Rolleyes

...but way easier than the enigma! Big Grin

: