Thanks!

Looks like that will get me started. It's really helpful...

I have another question but I'm off to a meeting.... but I wanted to say,
'Thanks' right away...



"RagDyeR" wrote in message
...
Missed the second part of your question.

Just play with the "-96" to get any number you wish.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"RagDyeR" wrote in message
...
Try this:

=CODE(LOWER(A1))-96


--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"James E Middleton" wrote in message
...
I am looking for an easy was to make a alphabet code game for my students.

I want to give them words or sentences to 'decode'

For example; 2-1-3-11 = back

8-5 12-9-11-5-19 3-1-20-19. = He likes cats.

Something as simple as Col A 1-4: b,a,c,k outputs in Col B 1-4: 2,1,3,11

I don't mind formatting it after into something useable, however, if it
was
possible:

In Row1 type the word or sentence, one letter in each cell, numbers are
output in Row2.

Thanks!

PS. if this can be done, is it possible to have the letters generate any
number as a code?

For example, a = 26, z = 1, or a = 10, b=20, etc