Thread
:
Letters and Number formulas
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
Posts: n/a
Letters and Number formulas
Try:
=IF(A8="","",IF(OR(CODE(UPPER(A8))<65,CODE(UPPER(A 8))91),"Not a
Letter",CODE(UPPER(A8))-64))
--
HTH
Sandy
In Perth, the ancient capital of Scotland
with @tiscali.co.uk
"2pojeff" wrote in message
...
I trying to write a formula where if I input any letter into a cell I want
the adjacent cell to display the alphebtic number of that letter.
Where A=1 B=2 etc etc Z=26
Example.
I put letter d in cell A2 I then want cell B2 to display 4
I put letter z in cell A2 I then want cell B2 to display 26
Reply With Quote