View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Flintstone
 
Posts: n/a
Default 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