I have created a lattitude/longitude spreadsheet, wherein I search the
lattitudes and longitudes of various cities in order to compute the distance
between them.
In my city "look-up" routines, I ALWAYS copy from cells H2 and I2 and paste

How do I split a cell with numbers and letters into 2 separate cells.  I have
tried the text to columns wizard and can't figure it out.  Here is an example
of what I am trying to split.  There are no spaces between the numbers and
letters.

Is there a way so that when my sheet is opened up the first time NOW will put
in the correct date in one cell and the time in another but when it is open
again the time wont change.
The sheet we use is sent to an individual and they inturn open it, copy and

with thanks from Bob,Rick,Ron and suleman ; I think my last question was not
complete. let me ask it clearly as below:
cell           include                                       reply        
cell      include       formula

  I want to use the ThisWorkBook BeforeSave event to prevent users from
saving the sheet if the sheet path is O:\XBOX\XBOX-Tier2\Customer
Support\Source\Reports"

How do we convert positive numbers into negative ones under one column?

Can I use an event macro to prevent the user from using the fill handle on
unprotected cells?
The issue is data validation. Column B has a list validation.
(For example: Tom1,Dick1,Harry1)

I have 5 pipeline reports from differnt sales people and want to combine it
into one master pipeline report.  i also need it to update when a sales
person updates their individual work shhet

I have a relatively simple score-keeping spreadsheet I am working on.
The normal format for the scores to be entered is like '48-1' or
'47-3', etc.  Some of the aggregates are the sum of various stages or
matches, which for various reasons are not necessarily in contiguous

Can anyone help me with this please.
I have written an Excel (XP) macro that has to start by selecting a range
based on the active cell and the 10 cells to its right.
How do I put this into VBA code please?

How can I import a delimited text file of 600,000 records in Excel?

I need to return the second to last value (providing it is greater than
zero) from a data range. I already have a formula to return the value in the
last cell, this being:
=IFERROR(LOOKUP(2,1/($D7:$X7>0),$D7:$X7),"-")

I am modifying an Excel sheet, and after making several changes to the
format, my sheet only prints in a miniature version in the top left quadrant
of the page (the layout orientation is landscape). How can I get my document
to start printing again in its full size?

I have the following code and what it does is find the name "James" in this
example and copies all the information that is associated on that row and
places it on Sheet2.
I need this code to be a little more flexiable, but cannot figure out how to

I can't see the drop down list that I have created.  Any ideas why?