Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I enter a formula in a cell so that letters= a number i.e..
How do I enter a formula in a cell so that letters= a number i.e Y=5, N=2.
|
#2
|
|||
|
|||
Not very sure on your intents,
but you might be thinking along these lines Set-up the reference table in say, Sheet2, cols A and B, from row1 down Y 2 N 5 Z 9 etc Then in Sheet1, if you input letters* in say, A1:A3 Z Y N *assumed case-insensitive you could put in B1: =VLOOKUP(A1,Sheet2!A:B,2,0) and copy B1 down to return the numbers corresponding to the letters in col A Z 9 Y 2 N 5 Alternatively, if you're entering single alphabets in col A, then putting in B1: =CODE(A1) and copying B1 down will also drive out numbers corresponding to the alphas (this time, it's case-sensitive, Y = 89, y = 121) A - Z yields : 65 - 90 a - z yields : 97 - 122 -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Alex" wrote in message ... How do I enter a formula in a cell so that letters= a number i.e Y=5, N=2. |
#3
|
|||
|
|||
Hi Alex
jason has answered you in microsoft.public.excel.worksheet.functions it is generally not necessary to ask the same question in more than one group as most of the responders read a number of different groups and doing this tends to fragment your answers. cheers JulieD "Alex" wrote in message ... How do I enter a formula in a cell so that letters= a number i.e Y=5, N=2. |
#4
|
|||
|
|||
"JulieD" wrote
..... it is generally not necessary to ask the same question in more than one group as most of the responders read a number of different groups and doing this tends to fragment your answers. The multi-posting refrain was also given to the OP in .misc (Yup, he did it there too ! <g) Multi-posting isn't as rare as multi-post backs* to multi-posts *by the OP -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Result Correct but value in the cell is wrong | Excel Worksheet Functions | |||
How can I write an if-then formula for 0 or less than 0 in cell t. | Excel Worksheet Functions | |||
How do I do math on a cell name in formula? | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
How to populate column with formula based on value in cell | Excel Worksheet Functions |