How can I convert a column from alpha to numeric?

i.e. convert BZ to 78

Is there a simple conversion or do I have to write my own?

I have data in cols A and B and BZ-CF.
How would I say :
Columns("B+1:BZ-1").Select
Selection.Delete Shift:=xlToLeft