alphabet to numbers?
 

I want to associate letters of the alphabet with numbers so that when a
letter is put in a cell, a numerical value can be associated. Sort of
like a phone pad-I want it so that you could put the letter in a cell
and a designated number would automatiocaly show up in another cell. Is
there a way to create a formula that can do this? Help would be greatly
appreciated. Thank you.


--
Loriandme69
------------------------------------------------------------------------
Loriandme69's Profile: http://www.excelforum.com/member.php...o&userid=28971
View this thread: http://www.excelforum.com/showthread...hreadid=487046

alphabet to numbers?
 

Hi Lori,

=LOOKUP(A1,{"a","b","c","d"},{1,2,3,4})

Exten in the same style as needed.

HTH
Regards,
Howard

"Loriandme69"
wrote in message
...

I want to associate letters of the alphabet with numbers so that when a
letter is put in a cell, a numerical value can be associated. Sort of
like a phone pad-I want it so that you could put the letter in a cell
and a designated number would automatiocaly show up in another cell. Is
there a way to create a formula that can do this? Help would be greatly
appreciated. Thank you.


--
Loriandme69
------------------------------------------------------------------------
Loriandme69's Profile:
http://www.excelforum.com/member.php...o&userid=28971
View this thread: http://www.excelforum.com/showthread...hreadid=487046

alphabet to numbers?
 

This should work also

=asc(a1)-64

"L. Howard Kittle" wrote:

Hi Lori,

=LOOKUP(A1,{"a","b","c","d"},{1,2,3,4})

Exten in the same style as needed.

HTH
Regards,
Howard

"Loriandme69"
wrote in message
...

I want to associate letters of the alphabet with numbers so that when a
letter is put in a cell, a numerical value can be associated. Sort of
like a phone pad-I want it so that you could put the letter in a cell
and a designated number would automatiocaly show up in another cell. Is
there a way to create a formula that can do this? Help would be greatly
appreciated. Thank you.


--
Loriandme69
------------------------------------------------------------------------
Loriandme69's Profile:
http://www.excelforum.com/member.php...o&userid=28971
View this thread: http://www.excelforum.com/showthread...hreadid=487046