Posted to microsoft.public.excel.misc
|
|
Giving a letter a numerical value
Hello
Try this
=CODE(UPPER(A1))-64
Matt
--
Flintstone
------------------------------------------------------------------------
Flintstone's Profile: http://www.excelforum.com/member.php...o&userid=15310
View this thread: http://www.excelforum.com/showthread...hreadid=519998
|