View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
rk0909 rk0909 is offline
external usenet poster
 
Posts: 50
Default Alphbet to number conversion

works great.

thanks much.

"RagDyeR" wrote:

For any case:

=CODE(UPPER(A1))-64

--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Gary''s Student" wrote in message
...
=CODE(A1)-64

for caps.
--
Gary''s Student - gsnu200764