To register for an Internet.com membership to receive newsletters and white papers, use the Register button ABOVE.
To participate in the message forums BELOW, click here
VBForums  

VB Wire News
MSDN Subscribers: Download the VS 2010 Release Candidate
MSDN Subscribers: Download the VS 2010 Release Candidate
Sell Your Code and Make Money?
Creating your own Tetris game using VB.NET
Article :: Improving Software Economics, Part 4 of 7: Top 10 Principles of Iterative Software Management



Go Back   VBForums > Visual Basic > Office Development

Reply Post New Thread
 
Thread Tools Search this Thread Display Modes
Old Mar 20th, 2007, 10:13 AM   #1
brellis1
Member
 
Join Date: Mar 07
Posts: 32
brellis1 is an unknown quantity at this point (<10)
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
brellis1 is offline   Reply With Quote
Old Mar 20th, 2007, 12:32 PM   #2
brellis1
Member
 
Join Date: Mar 07
Posts: 32
brellis1 is an unknown quantity at this point (<10)
Cool Re: Map Location Extractions in Excel

I'm jsut stupid....I figured it out
brellis1 is offline   Reply With Quote
Reply

Go Back   VBForums > Visual Basic > Office Development


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

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 09:56 AM.




To view more projects, click here

Acceptable Use Policy


The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.