Hey

What code will extract only the column letter and then row
number from the below sample data?

Sheet1!$K$8
The desired outcome is a variable that will store K and
another variable that will store 8

Sheet1!$AC$108
The desired outcome is a variable that will store AC and
another variable that will store 108

Sheet1!$F$92
The desired outcome is a variable that will store F and
another variable that will store 92


Thanks in advance.
Todd Huttenstine