Enumerate a Cell Notation

Microsoft Excel, 43 Bytes.

=COLUMN(INDIRECT(A1))&" "&ROW(INDIRECT(A1))

I couldn't help myself, I just had to use the right tool for the job. Takes input on A1.

Test Cases


Microsoft Excel, 40 bytes

Brasilian Portuguese language version.

=COL(INDIRETO(A1))&" "&LIN(INDIRETO(A1))

Translated (and therefore golfed) version of ATaco's solution.


Python 2, 94 91 73 bytes

-3 bytes thanks to Jonathan Allan
-18 bytes thanks to tsh

s=input().strip
a=s(`3**39`);t=0
for n in a:t=t*26+ord(n)-64
print t,s(a)

Try it online!

This abuses the way that .strip works, removing all digits wtih a=s(`3**39`) where `3**39` is just a shorter way to generate the digits from 0 to 9, this will store only the chars on a that will be used to strip the chars from the numbers on s(a)