Hasty8
01-27-2005, 04:48 PM
Got a quick question.
Let me preface by saying this - I stink at Excel so any offering of help, please dumb it down to kindergarten level.
Thanks.
So I have a list of two digit numbers that represent the numbers of the alphabet.
A=21
B=22
C=23
D=31
etc
These numbers are used to enter a callers name in the dial by last name function on the corporate phone system. I have to create a list with all the employees names converted into their numerical counterparts.
We have over 5000 employees.
What I would love is to be able to enter a single letter into a cell and have the equivalent number pop up under it. That way I can enter a name in a row, one letter per cell and have the numerical equivalents showup underneath.
Is there any way to do that in either Excel or Access?
Again, I'm a moron so please dumb it down.
Thanks!
I can email a spreadsheet with the numbers and a few names if you need. Just PM me for that.
Let me preface by saying this - I stink at Excel so any offering of help, please dumb it down to kindergarten level.
Thanks.
So I have a list of two digit numbers that represent the numbers of the alphabet.
A=21
B=22
C=23
D=31
etc
These numbers are used to enter a callers name in the dial by last name function on the corporate phone system. I have to create a list with all the employees names converted into their numerical counterparts.
We have over 5000 employees.
What I would love is to be able to enter a single letter into a cell and have the equivalent number pop up under it. That way I can enter a name in a row, one letter per cell and have the numerical equivalents showup underneath.
Is there any way to do that in either Excel or Access?
Again, I'm a moron so please dumb it down.
Thanks!
I can email a spreadsheet with the numbers and a few names if you need. Just PM me for that.