Results 1 to 2 of 2

Thread: Map Location Extractions in Excel

  1. Mar 20th, 2007, 09:13 AM #1
    brellis1
    brellis1 is offline

    Thread Starter
    Member
    Join Date
    Mar 2007
    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
    Reply With Quote Reply With Quote
  2. Mar 20th, 2007, 11:32 AM #2
    brellis1
    brellis1 is offline

    Thread Starter
    Member
    Join Date
    Mar 2007
    Posts
    32

    Cool Re: Map Location Extractions in Excel

    I'm jsut stupid....I figured it out
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width