eg if A=1 ... when I enter 'A' in one cell I get '1' in another.
2007-03-11 21:23:27 · 5 answers · asked by Euka 1 in Computers & Internet ➔ Software
Make 2 columns as a data table
A...1
B...2
etc...
Then use one cell as data entry point, and the adjacent cell for result.
In result cell write the lookup formula:
"=lookup(,
You can replicate the formula for multiple cells. Cheers Mate!
2007-03-11 21:29:28 · answer #1 · answered by Tiger Tracks 6 · 0⤊ 3⤋
1
2017-01-19 23:09:20 · answer #2 · answered by ? 4 · 0⤊ 0⤋
=CODE(...)
=code("A") gives 65, so if you wanted the result to be 1 (and 26 for "Z" use =code([cell reference])-64.
from Excel Help:
CODE
Returns a numeric code for the first character in a text string. The returned code corresponds to the character set used by your computer.
Syntax
CODE(text)
Text is the text for which you want the code of the first character.
Example
=CODE("A") Displays the numeric code for A (65)
=CODE("!") Displays the numeric code for ! (33)
2007-03-11 22:24:28 · answer #3 · answered by Anonymous · 1⤊ 0⤋
I Understand ur requirements !!
I already coded in VB.
(Eg If you type "A" then print 1, If "Z" then 26, If "AA" then 27 and so on).
If you want this code then just mail me confirmation, I'll send to you
2007-03-11 22:01:04 · answer #4 · answered by Dewang Shah 2 · 0⤊ 1⤋
Sure
=CODE( UPPER( A1))-64
that is all you need to work for both "A" and "a"
Enjoy my profile, I am the VBAXLMan
2007-03-14 02:23:43 · answer #5 · answered by Anonymous · 0⤊ 0⤋