Map Location Extractions in Excel

brellis1 · Mar 20th, 2007, 10: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, 12:32 PM

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

Mar 20th, 2007, 10: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, 12:32 PM	#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	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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