View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bernd Bernd is offline
external usenet poster
 
Posts: 92
Default Coverting Alphabets into Numbers

Hello Marcus,

Just for the fun of it: If you like to decrypt via worksheet
functions, I suggest to use
=SUMPRODUCT(MOD(CODE(MID($A$1,ROW(INDIRECT("1:"&LE N($A$1))),1))-64,10),
10^(LEN($A$1)-ROW(INDIRECT("1:"&LEN($A$1)))))

Regards,
Bernd