Hi:
I have a cell containing Last and First Name. In most cases the
Lastname and Firstname are seperated by a comma. Also in this same
field there is a telephone number which can be in several different

I've built a workbook to keep up with purchase/sales of Stocks, to keep
up with long & short term Capital/Gains for Tax records.
The way that the sheet is built is: A1 thru G2 are used for entering
stock purchases; name, date bought, price, # of shares with sum formula

I have entered some coding so that when my spreadsheet open, all user
values are set to zero (default values).
How do I add a button to my worksheet for the user to click on to reset
the values to there defaults while working on that sheet

I'm stuck.  Using Excel 2002, Win XP Pro
Here's a two-column data table and one column is where I enter a daily
number.  The next column shows the difference between the present day and
the day before as a positive number.

I have a cell that uses validation to return a number.
A    B
a = 1
b = 2

I am trying to obtain an average of blood pressure over a period of time.  
The individual entries are in a single column but are in a combined format
(e.g. 130/82).  I need to parse each of the two numbers and arrive at an
average of all entries in the column.  I have searched ...

I need to total (count) all the pivot table entries displayed in A:C
where A is between the 30 minute intervals that I have in F and G per
colour listed in B.
I have tried

I have a row that calculates various results.  The user inputs th
choices from a cell that has validation.
Now when the row has been completed, you have a total which is fine.
Now, when you open the workbook again, the previous selected option

If I have the time 14:45 and I wanted to add say 10 minutes to it, how
would I do this please.
Thanks in advance.
All the Best.

This might not be the right area however i am a newbie to Excel so
figure i'd start here. I have very limited experience with Excel s
excuse me if i don't make sense.
ANY HELP IN THE RIGHT DIRECTION WOULD BE AWESOM

My AutoFill little black square is not showing up.  I already checked to see
if it is ON, and it is.  Now what; please help me!!!
Thank you ~

Need to import .csv files into a application with quotes around the values in
a field.
Excel is stripping off quotation marks from .csv files if the field contains
a number.

I need to count the number of cells in one column that contain a date that is
<= today's date.  The dates are currently formatted as "General" numbers
rather than being formatted as "Date"

I'd like to make a list inside a cell, in which you can choose the
sentence you would like to have into that specific cell.
For example:
I would like to have the following list into, say, cell F4:

When I try to copy a file I'm told it can't be copied because it is a read
only file.  I go to Tools - Options-Security - and there is a box there for
Read Only  it is not checked so I can't uncheck read only.  How do you change
a file from Read Only to not Read Only????