Converting characters to numbers
 

G'day all
I'd like to know if there is a way to convert characters/letters (A-Z) into
numbers/values of my own choice in Excel, using either formulas, macros
(functions) or otherwise. Any ideas?
Cheers,
Robbie aka Zoqaeski

Hi

On some sheet, p.e. List, create a list of characters with corresponding
numbers in next column. Let you have this table in range List!A1:B25.

Now, when you have on some sheet a character in cell, p.e. A2, the
corresponding number is retrieved with formula
=VLOOKUP(A2,List!$A$1:$B$25,2,0)
(Whenever you edit the table on sheet List, all corresponding numbers are
recalculated, of course!)

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"Robbie aka Zoqaeski :p" <Robbie aka Zoqaeski
wrote in message ...
G'day all
I'd like to know if there is a way to convert characters/letters (A-Z)
into
numbers/values of my own choice in Excel, using either formulas, macros
(functions) or otherwise. Any ideas?
Cheers,
Robbie aka Zoqaeski

Thanks for that, Arvi, but this formula of yours does not like 0 (zero), for
some reason, and I need to be able to use it, because what I am trying to
develop is a check digit calculator for railway vehicles.

"Arvi Laanemets" wrote:

Hi

On some sheet, p.e. List, create a list of characters with corresponding
numbers in next column. Let you have this table in range List!A1:B25.

Now, when you have on some sheet a character in cell, p.e. A2, the
corresponding number is retrieved with formula
=VLOOKUP(A2,List!$A$1:$B$25,2,0)
(Whenever you edit the table on sheet List, all corresponding numbers are
recalculated, of course!)

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"Robbie aka Zoqaeski :p" <Robbie aka Zoqaeski
wrote in message ...
G'day all
I'd like to know if there is a way to convert characters/letters (A-Z)
into
numbers/values of my own choice in Excel, using either formulas, macros
(functions) or otherwise. Any ideas?
Cheers,
Robbie aka Zoqaeski

Hi

What do you mean with 'does not like 0 (zero)'. Is this 0 in column with
lookup values (characters), or in return values (numbers), or in condition
cell. And what does the formula do, when this 0 occurrs, and what you want
it to do. There is a lot of combinations of to consider of, so I can't help
you without further information.

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"Robbie aka Zoqaeski :p"
wrote in message ...
Thanks for that, Arvi, but this formula of yours does not like 0 (zero),
for
some reason, and I need to be able to use it, because what I am trying to
develop is a check digit calculator for railway vehicles.

"Arvi Laanemets" wrote:

Hi

On some sheet, p.e. List, create a list of characters with corresponding
numbers in next column. Let you have this table in range List!A1:B25.

Now, when you have on some sheet a character in cell, p.e. A2, the
corresponding number is retrieved with formula
=VLOOKUP(A2,List!$A$1:$B$25,2,0)
(Whenever you edit the table on sheet List, all corresponding numbers
are
recalculated, of course!)

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"Robbie aka Zoqaeski :p" <Robbie aka Zoqaeski

wrote in message
...
G'day all
I'd like to know if there is a way to convert characters/letters (A-Z)
into
numbers/values of my own choice in Excel, using either formulas,
macros
(functions) or otherwise. Any ideas?
Cheers,
Robbie aka Zoqaeski