The problem appears to be in some combination of text that I used in my
other posts... each of my prior attempts contained the same quoted text
(because that is what I wanted the OP to see), so each was rejected because
of whatever reaction that particular text combination triggered in the
Microsoft servers... here, I didn't quote any of that other text, so my
response went through as a normal posting.

--
Rick (MVP - Excel)


"T. Valko" wrote in message
...
So, how were you able to make this reply but the others are "lost in
space" ?

--
Biff
Microsoft Excel MVP


"Rick Rothstein" wrote in message
...
For those wanting to see the responses that I can't seem to post here,
Biff discovered (and told me about it in a private email) that Google
Groups has it archived even though it won't show up here. I have no idea
how that can be, but it is. Here is the link...

http://groups.google.com/group/micro...747caeed555a69

--
Rick (MVP - Excel)


"Karto" wrote in message
...
Hola everyone,

I am trying to convert Alpha into a Numeric response so that depending
on
what Letter is typed in one field, a Numeric response is returned in
another.

ex:
if A1 = A or B then A3 = 1
if A1 = C or D or E then A3 = 2
if A1 = F or G then A3 = 3
if A1 = H or I or J then A3 = 4
if A1 = K or L then A3 = 5
if A1 = M or N or O then A3 = 6
if A1 = P or Q then A3 = 7
if A1 = R or S or T then A3 = 8
if A1 = U or V then A3 = 9
if A1 = W or X or Y or Z then A3 = 0
(basically a modified telephone keypad)

Thanks for any help