I need to merge over 20,000 first and last names and figured out how to do
that in concatnate, but I can't copy the formula into the other 19,000 names
I need to do.  Can I do this?

I accidentally closed an excell spreadsheet that I had worked on for over an
hour and had not saved.  Is there a way to retrieve this file (I'm assuming
that it automatically saves it to a temporary folder???)?

I want to display the date when money is received, and I do not want the date
to change everyday.
Ex: =IF(K24="Yes",TODAY(),IF(K24="No",TODAY(),""))
However, this formula gives today's date and changes each day.  I don't want

How can i disallow other users to copy my work sheet or entire file.

Thank  you very  much.

In Column A, I have 2 years of dates from A2: A732, with the function
"Match" I can locate the cell reference of a specific date but I would like
to be able to go to that cell directly if its possible. I know the function
"Go To" will take me there but am looking for something ...

Is it possible to someway make a date in a cell comment alert you when its due?

I have an excel spreadsheet that pulls sales order information (through MS
Query) from a client's accounting system. One of the cells then concatenates
two cells together to generate a unique value of the Customer Account Number
& Product Number

I have got a list of companys with abbreviated names with our purchase spend
with each company, I also have a master list of what the abbreviated names
full alternative. When I do a report at the end of each month the list comes
out with the abbreviated names but I want the full ...

I am trying to select from a column of 30-40 cells (cells that are not blank)
and combine them into one cell. I am using concatenate but formula will be
too long.
Eg of my formula

Is there a way to paste unformatted text, the equivalent of 'match
destination format' from the drop down box after doing a paste. I would like
to create a ,macro to do this ot assign a keyboard shortcut to an already
existing command, if one exists. I am trying to avoid having ...

I've got a spreadsheet with a large quantity of dates that cross over several
financial years.  Is there a simple way to produce a pivot table to group
these dates by financial year, ie from Jul 06 to Jun 07, then Jul 07 to Jun
08 etc?  The dates are entered as dd/mm/yyyy format. ...

Item I.D.    Cost    Total Packs
a    200    136540
b    200    133530
c    200    72920

Have a variation to a previous question:
Need to copy a string of characters from one cell to another. Here is what
the cell looks like:
Cells:

I several cells with that needs to contain 9 digits or less, with all of the
characters being numeric.  Is there a way I can limit the
characters entered to be all numberic (no alpha, no other characters)?  
Thanks for your help.