| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Column headings are numbers instead Alphabet Letters | Setting up and Configuration of Excel | |||
| Seperate Alphabet and numbers in a cell | Excel Discussion (Misc queries) | |||
| Why can't I autofill the alphabet? | Excel Discussion (Misc queries) | |||
| associate alphabet letters with numbers? | New Users to Excel | |||
| alphabet as Numbers? | Excel Discussion (Misc queries) | |||
Linear Mode
