Column:
=COLUMN(INDIRECT(A1&"1"))

Row:
=ROW(INDIRECT(A1))