Hi

I assume the result should be in the next COLUMN

With A,B,C ...Z in A1:A26, enter in B1
=CODE(A1)-65+ROW(A1)
and copy down

--

Regards
Roger Govier

"PRASHANT" wrote in message
...
DEAR FRIENDS,

I WANT TO ASSIGN NUMERIC VALUE TO ALPHABET
FOR EXP.

A=1,B=3,C=5 AND SO ON UP TO Z AND THE RESULT SHOULD BE STORED IN THE NEXT
ROW