Return a number from a letter input.

[serge]

I'm looking for a formula that will return:
Starting in J7 a 1 for the letter A, 2 for the letter B etc...

Thank you.

Excel Workbook
	D	E	F	G	H	I	J	K	L	M	N
7	A	B	B	E	J		1	2	2	5	10
Sheet

 

[Tetra201]

Try putting the following formula in cell J7 and copying it through cell N7:

=CODE(UPPER(OFFSET(J7,,-6)))-64

 

[Momentman]

For one-letter alphabets, this should work

Excel 2010
	A	B	C	D	E	F	G	H	I	J	K	L
1		D	E	F	G	H	I	J	K	L	M	N
2	7	A	B	B	E	J		1	2	2	5	10
Sheet1

Cell Formulas
Range	Formula
H2	=CODE(B2)-64

or set-ip a lookup tble and use vlookup

 

[serge]

Woaw, it works perfect, Thank you very much Tetra201, much appreciated.
Serge.

 

[Tetra201]

You are welcome.

 

[serge]

Thanks, Momentman it works very nice too.

 

[Momentman]

Thanks, Momentman it works very nice too.

Tetra's is more robust, just gave a simple version you could work with