using indirect(), you can skip the substitute() and just pipe in the row number.
=SUBSTITUTE(ADDRESS(1,( COLUMN( INDIRECT(A1&1) ) + 1 ),4),1,'')Įxample reading a cell A1 that contains a number to be treated as a column number (e.g.
=SUBSTITUTE(ADDRESS(1,( COLUMN(Z1) + 2 ),4),1,'')Įxample reading a cell A1 that contains a letter as text to be treated as a column letter: In this example, it's taking the current column and adding 1, so returning B if it's in column A and AA if it's in column Z.Įxample adding to a fixed column (adding 2 to column Z, returns 'AB'): The part in the middle marked in bold is the only part that changes.
