Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
associate alphabet letters with 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=487034 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
associate alphabet letters with numbers?
VLOOKUP()can help.
For example, make a table from A1 to B7: a 1 b 2 c 3 d 4 e 5 f 6 g 7 and put =VLOOKUP(C1,A1:B7,2,TRUE) in D1. Then in C1 put a letter and D1 will return the equivalent value -- Gary's Student "Loriandme69" wrote: 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=487034 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
associate alphabet letters with numbers?
Another option, try CODE()
With the single alphas listed in A1 down: A, B, C, ... a,b,c ... Put in B1: =CODE(A1) Copy B1 down Upper case A - Z returns: 65 - 90 Lower case a - z yields: 97 - 122 If required, apply a simple arithmetic adjustment to the numbers returned by CODE, e.g. use : =CODE(A1)-64, =CODE(A1)-96, etc -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "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=487034 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
associate alphabet letters with numbers?
Thanks for the Help! -- Loriandme69 ------------------------------------------------------------------------ Loriandme69's Profile: http://www.excelforum.com/member.php...o&userid=28971 View this thread: http://www.excelforum.com/showthread...hreadid=487034 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
associate alphabet letters with numbers?
The suggestion was slightly off the "beaten" track, admittedly, but unlike
VLOOKUP, it's an alternative to consider if case sensitivity on the alphas is desired. -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change format of page numbers to letters in Excel? | Excel Discussion (Misc queries) | |||
How do I set up formulas with letters and numbers? | Excel Worksheet Functions | |||
why have column letters changed to numbers in excel | Excel Discussion (Misc queries) | |||
row numbers & column letters | Excel Discussion (Misc queries) | |||
How do I change column labels from numbers to letters in Excel? | Excel Discussion (Misc queries) |