Hi, I have been trying to figure this one out, but I have not been able
to.

I have an alphanumeric code - say BC983X8 - in a cell, and I need to
calculate an extra digit based on it. Each letter has a value (place
in alphabet+9). How can I do this?


--
usingexcel
------------------------------------------------------------------------
usingexcel's Profile: http://www.excelforum.com/member.php...o&userid=37043
View this thread: http://www.excelforum.com/showthread...hreadid=567955