Thursday, February 27, 2014

MS Excel: Show Alphabetic Row or Column Number

To show row number in alphabetic order, simply right this formula is first location where you wish to start the alphabet i.e. A and then, drag and paste the formula in rows below:

=SUBSTITUTE ((ADDRESS (1, ROW (A1), 4)), 1,"")

Same the case of alphabetical column numbers, at start point, write the following formula and drag and paste on adjacent columns:

=SUBSTITUTE ((ADDRESS (1, Column (A1), 4)), 1,"")