I have a number and a description (which may at times also contain a number
as well as -) within a cell in excel separated  by a - . How do i extract
only the number at the front as in the subject. Numbers are of varying
lengths.

I need to delete my second page in excel. Any suggestions?

I am trying to copy two sheets from one file into a new file.  I receive the
following message:  "The sheet you are copying has cells that contain more
than 255 characters.  When you copy the entire sheet, only the first 255
characters in each cell are copied.  To copy all of the ...

In Excel 2003, I went to Tools>Add-Ins>Financial Tools
The following icons become available:
New Financial Report
Load Financial Data

OK. I have 4 colums in my table on sheet 2.
In the cell on sheet 1 I want to look at Sheet 2, Column 1 and (if it
contains anything) add columns 2, 3, and 4 together for that row. Then
Average these sums in one total.

One page in Excell 2005 suddenly started putting all the dates just numbers,
such as 39443.  I can copy a cell with a number and paste it into another
cell in another page and it will display the correct date.  I've tried
formatting the cells but nothing I've tried will work.

I wish to run a macro after clicking into various cells.
I have 10 different macros and 10 cells with names of these macors and
I wish to run the relevant macro when I click into the cell.
ie.  A1 content = "Scores" and when I click into that cell, I wish the

Excel 2000 without add-ons
I have two cells that contains text  cell1:"20/30" and cell2: "45/100"
I would like two formulas that combines the first part, or the second
part of the cells and gives me the result "20/45"and in another cell

I need to put a currency amount in a cell and have Excel automatically spell
it out and replace the number in the cell.  Any ideas???

Hi there, I am trying to create a formula for the data below that would add
volumes in column C that coorespond to the "Wash" and "Blend" (not
Blend50/50) in Column B seperately for the categories Concrete and Rock.  Is
there a formula that could do this for me?

Is there any better way to write this count if statement?
I need it to look up four different columns and count if they contain any
money.  Is there a shorter way to write this or am I stuck?
=COUNTIF('CALICO Unmapped Not Active'!T6:T42,">0")

Hi all.  In sheet1, cell A1 I have a pick list that has all the sheet
names in the workbook.  In cell D5, I need a formula that is a cell
reference to B75 of whatever worksheet is selected in cell A1.  Any
ideas?  Thanks!

2007 excel sumifs problem,
I am trying to us a sumif with multiple ranges and criteria but am having on
bug, with cell referenceing when using it with a greater or less than
criteria.

TYPING NUMBERS IN A CELL
WHEN I GO TO ANOTHER CELL THE NUMBERS APPEAR DIFFERENT AND WITH + SIGNS LIKE
THIS   5.63209E+11
HOW DO I CLEAR IT ?

I write a function for compiling students exam results:
Knowledge    Scienctif Process    Complex Reasoning
 >80%                  >80%                              60%                
Very High Achivement