Thanks, I will give this a try.

"daddylonglegs" wrote:


You could construct a table and use a VLOOKUP formula or, alternatively,
if you have a consistent pattern as per your example then with letter in
A1 use this formula in B1

=(CODE(UPPER(A1))-64)*6

this would give you 6 for A, 12 for B etc.


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=541855