I used the concatenate function to combine columns of Last Name, First Name,
Middle Initial.  Now, I want that combined information to remain and I want
to delete the three separate columns.  How can I do that without losing the
concatenate function?  Thanks!

i want to have two drop down lists in my spreadsheet.
When i select an option on the first drop down list i want the second drop
down list options to change accordingly. e.g. if i choose breakfast on the
first drop down i want "cereal", "toast" etc to appear as options on the

on a data sheet all data is imputed - sheet 1
I have a range of cells ie a7 to a2028 with dates in them
next range of cells b7 to b2028 has either the letter s or c in them
next range of cells c7 to c2028 has numbers in them

I have a sheet that figures dates, it can go back 3 years the user now puts
in the dates for each year needed,  it looks like this
4/1/05 to 12/31/05     penalty amt.   39wks   2days  Year2005
1/1/06 to 12/31 06     penalty amt.   52wks   1 day   Year2006

Is it possible to have a list of grades in a column as text i.e
A
A
B

I am trying to create a formula which will look at dates (D3:D100) and count
ones which are earlier than TODAY() but to ignore blank cells too.
Thanks

I want to print out a spread sheet with subtotals on each page but the number
of rows and height of rows maybe different each time and I don't want to have
to manually adjust the print area and move the subtotal row around. Is there
anyway to do this automatically in Excel or do ...

The number i put in cell  A31 must be ditributed randomly from cell A1 to
A30 so the summary of A1 to A30 must be like A31. Is this possible?
Farmer

Exel 2002. Vista Home Premium. Is there a function that will calculate the
total number of days in each month. I need to average totals against the
number of days in each month. For example, $40,000 / number of days in the
month. I would like to make it a formula so I can copy it ...

I want to return the File Property value of the excel file's last modified
date to a cell in a worksheet.  Is this possible?  I seem to recall that
there may be some way of using EXCEL4 macro, but cannot remember how.  Or
perhaps there is an easier way.

Is there an easy way to view/highlight all protected cells on a sheet at once ?
I have 12 sheets and I want to check all the right cells are protected in
each.
thanks

Just reading through the messages it seems that I have
to get a text converter program of sorts in order
to convert adobe files to excel.  I have tried copying
and pasting from adobe and then trying to convert text to columns

I need for a formula to recognize a blank cell and do nothing however when i
put a zero in the blank cell I need the formula to work, right now it is
looking at the blank cell and zero as the same and preforming the formula.
any suggestions.

i want to have two drop down lists in my spreadsheet.
When i select an option on the first drop down list i want the second drop
down list options to change accordingly. e.g. if i choose breakfast on the
first drop down i want "cereal", "toast" etc to appear as options on the

Greetings,
I found a solution to my copy and paste problem in the archives.
the problem is that I need to paste an empty cell as a choice in my IF
statement.  Here is the formula in the cell called pfCell_1: