Convert Letter to number

[sveinhelge.urdal]

I have a spreadsheet with one coumn contaoing drawing revision. This can be either number or letters.
I want to create a new column where the revision letter is changed to a number. A=1, B=2 ...
Where the revision is a number I want the new coumn to leave the cell empty.
Anyone who can help?

 

[bosco_yip]

Maybe………

=IF(N(A1),"",CODE(A1)-64)

Regards

 

[sveinhelge.urdal]

Thanks, but this do not work. Excell returnes #NAME?

 

[Riyaz Ali]

Thanks.... was not aware of the N function.... will use it in one of the dashboard

 

[sveinhelge.urdal]

I have added a copy of some of the lines in my workbook.
I want Excel to return the number of the letter in the alphabeth from column E into column J and leave empty if E is a number.

 

[vletm]

Copy next Module1 and
use in sheet like cell A2 write =ColLetterToNum(A1)

Function ColLetterToNum(ByVal sColLetter As String) As Long
    Application.ScreenUpdating = False
    ColLetterToNum = ActiveWorkbook.Worksheets(1).Columns(sColLetter).Column
    Application.ScreenUpdating = True
End Function

and You could get all columns letters (not only until Z) show like numbers

 

[bosco_yip]

In J2, copy down :

=IF(N(E2),"",CODE(E2)-64)

Regards

 

[Riyaz Ali]

Attached....

 

[sveinhelge.urdal]

Thanks. Just the functionality I was looking for.