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