Code covered by the BSD License  

Highlights from
Convert an A1-style spreadsheet column label to a number.

  • abc2num(S)ABC2NUM convert a spreadsheet label string to corresponding column number.
  • num2abc(D)NUM2ABC returns spreadsheet string equivalent to the specified integer.
  • View all files
image thumbnail

Convert an A1-style spreadsheet column label to a number.

by

DS (view profile)

 

19 Feb 2007 (Updated )

ABC2NUM translates an A1-style (absolute) column label reference to a number; NUM2ABC does inverse.

abc2num(S)

Contact us