Thank you in advance for your help.
I have an address label file in .rtf format. It has 3 X
10 labels on one page totally about 14,000 address
labels. I wanted to convert it into MS Excel 2002 so i

This may not be possible but I'd like to ask. Is it at all possible to send
e-mail directly from XL even if there is no e-mail account setup on the pc?
The pc is connected to the internet 24/7, it is setup for web access but
there is no application setup for e-mail. I'd like the ...

How can I create a formula to read across a row with 30
columns and tell me where the first non-blank value is.  
In the example below, I want the formula to read across
Row 1 and tell me that the value "2" is located in cell

i receive a worksheet from my broker and i want to use that data in another
worksheet. I want do to some daily calculations on that data and become
tired of copying it by hand. I searched for a way to copy a certain range,
but nothing found yet. I wonder if someone could help me.

I need to multiply a range of cells together that may or
may not have 0's or empty cells within the range.  But of
course, if you mutliply by 0 you get 0.
My formula needs to calculate even if there is 0's or

I have data from chromatograms which result in Tr and PH
for each peak(total # of peaks=150).i Have 50 samples
each sample has some or all of the entries but not all so
the rows do not match as you go down the spreadsheet. I

Excuse me jumping straight in - I lurked and posted a long while back
but have been absent for a while
I want to be able to paste the clipboard in TEXT form into the current
cell

Hi,
i need to count items when the criterea is met in two cells.  For
example, countif cell a = accounts and cell b = 2.  I will be counting
these in a colum.  Any ideas?

I have formated cells that contain the results of a
formula.
I want to copy the results (copy/paste) from one worksheet
to another and KEEP the results. when I copy and paste,

Hi. In Excel 97, I need to compare a cell value from a lookup table and get the associated value. i.e
if the cell value value is 1-10, return 1, if 2-20, return 2, etc
I guess I’d create a lookup table somewhere on the spreadheet and preferably name it
I’ve tried VLOOKUP function ...

I have a new system using MS XP and MSOffice 2003.  When
the user attempts to save an Excel spreadsheet it takes
between 90-120 seconds to save the document.  Any idea's?
Bill Harvey

I am looking for some guidance in writing an array
formula that will identify the cell reference of the
First Occurrence of a date in a given row, going right to
left.

hello..I have a Transmittal in Excel for sending out our
drawings to customers and I want to log all transmittals.
If i have the "To:" (company name) in Cell A3 and the date
in Cell D3,the transmittal number in Cell D4, the project

I have a sheet that lists
Salesman    Model    Pric
Paul    Jetta    1000
John    Jetta    1000

I am getting a circular reference in a DSUM in Excel 97.
Their are several DSUMs that are almost identical, and
only one gives me a circular reference. They all have the
same database range and field but refer to different