I need to have 14 characters in a line that contains words.  How do I fill
the empty spaces with zeros?

I have a text data stored in same cell of different worksheets on the same
file. I need to list them down in a single fresh worksheet. Is there any
formula or any way that I may use?

I want to add a column of numbers (column AL, which contains #.# Grams) if
column C (dates) is between a range of dates (ie.  between 1/1/06 and
3/31/06).
I could use sumproduct if it was text, to count the number of occurrances of

I'm looking for a formula to find the 'best fit' for inventory turns.  For
example:
   A      B      C      D
1  10    100   50    5

How to set COUNTIF, in order to count "nonblanks"? Which is the
parameter?
">0" is not the best idea...
And generally, where can I find info about all parameters, used in

Have two different workbooks with company names in columns and looking to
build a formula or macro that will compare each column in each workbook and
return differences.

Is there a way to find the first occurence in a list of unsorted values that
is greater than a specific lookup value?
The list is a column of unsorted numbers such that if A1:A5 = 7,4,10,5,9 and
the lookup value is 8 it would return 10 (or row 3).

I have thousands of rows in my spreadsheet and I need to identify the cells
that contain more than 30 characters.  I know how to do a Validation on a
cell but that only flags me when I enter data into the formatted cell, not
when data already exists.  Any ideas?

I want to go to the last cell on the worksheet and select it along with 16
prior cells in order to delete the last 16 rows of the worksheet at once
instead of deleting one row at a time.
Thanks!

I want to go to page 15 in a workbook but I am on page 75.  How do I get to
page 15 without scrolling?  Is there a shortcut?

I work with DNA and would like to assign numerical values to the bases. i.e.
A = 32 etc.
Ideally, I just want to past a DNA sequence into Excel, e.g. ATGCCA and then
have a numerical display of the value obtained if these are summed. e.g. if

If in cell A1 I have a month name for example: 'January'
In cell D1 i want to say, if the month in cell A1 says 'January' then  add a
month and show 'February' in cell D1 and so on so that in cell G1 i want to
say if cell D1 shows 'February' then add a month and show 'March' in ...

How do I read the system "last modified date" and place it in a document
automatically?

Here's what I have been trying:
=SUMPRODUCT((CaseData!C2:C1000>=DATE(2005,10,1))*(CaseData!C2:C1000<=DATE(200,12,31))*(CaseData!AT2:AT1000="Heroin")*CaseData!AU2:AU1000)
for the follwoing data
           C                  AT                 AU

Hopefully someone can help, in column A i have over 1000 part numbers (some
of which are duplicated many times) and in column B i have values ranging
from 1 to 320 which correspond to column A part numbers. The header in
column A is Part Numbers and the header in column B is Days ...