Map Location Extractions in Excel

brellis1 · Mar 20th, 2007, 09:13 AM

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

brellis1 · Mar 20th, 2007, 11:32 AM

I'm jsut stupid....I figured it out

Mar 20th, 2007, 09:13 AM	#1
brellis1 Member Join Date: Mar 07 Posts: 32	Map Location Extractions in Excel 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

Mar 20th, 2007, 11:32 AM	#2
brellis1 Member Join Date: Mar 07 Posts: 32	Re: Map Location Extractions in Excel I'm jsut stupid....I figured it out

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)