Excel column name to number converter
To convert a column number to an Excel column letter (e.g. A, B, C, etc.) you can use a formula based on the ADDRESS and SUBSTITUTE functions. In the example shown, the formula in C5 is. Find Excel column number from column title; Removing row or column wise duplicates from matrix of characters; Check if a grid can become row-wise and column-wise sorted after adjacent swaps; Search in a row wise and column wise sorted matrix; Given a number as a string, find the number of contiguous subsequences which recursively add up to 9. =COLUMN(ADX1) Using the Excel Object Model to convert a column letter to column number. Getting the column index is easily accomplished using the Excel object model. You first need to get a reference to a range object and then get the column number via the .