This is a basic VB coding question. Basically, in my cells of Excel I have a number and a couple of letters to represent location. I need to use VB to seperate out the number from the letters and store them in variables so that I can determine location. Then I need to determine a number based on the letter. I just can't remember how to isolate the letters and numbers.

For example:

Cell A1=AA14

I need to have a variable: Y=AA which will equal 27
X=14