Enumerate a Cell Notation
Microsoft Excel, 43 Bytes.
=COLUMN(INDIRECT(A1))&amp;&quot; &quot;&amp;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