Using XL2002 for Windows, I want to extract and add numbers from cells.
for example, let the following 3 lines each represent 1 cell.
D2K13 V0F4
Y2

I have a file on excel that contains many text entries of peoples names.....
A10 has Ken in it
A11 has Bill in it
A12 has Alan in it etc etc etc....

I use excel to prepare duties at work.........basically i have 6
workbooks......monday thru to saturday....I have everyones start and finish
times, aswell as a breakdown of tea break...meal breaks etc......
Is there a way I can take the values of a particular cell.....say B 10 ...

Hi I have a report which picks up data from a pivot table using the
GETPIVOTDATA function.
e.g. =GETPIVOTDATA("Total",Electricity!$A$3,"Planning
Group",$A5,"Sub-Transaction",D$2,"Summary","Energy Price")

I've never used excel before... i just have a simple graph of absorbance vs
concentration, and i have to interpolate values for concentration from values
of absorbances.
I read somewhere to use solver, but i can't figure out how to load it... i

As the subject says, I am trying to create a form letter in Word 2000
from an Excel 2000 spreadsheet, but when I try to to open the data
source, I get the following error: "Word found no mail merge fields in
your main document".  How do I create mail merge fields?  Can anybody

I must be missing something - how do I am working on two sheets within the
same spreadsheet and need to arrange horizontally. I click Windows:Arrange
and have tried checking and unchecking Windows in Active Workbook but
nothing does it.

Folks  please bear with me - I'm new to Excel and maths is not my
strong point.
I need to display minutes as time in hours and minutes.
I have worked out how to display a total number of minutes as a decimal

I have a user who opened an Excel spreadsheet, which is already open by
another user.  "[Read-only]" is written in the title bar at the end of
the file name, but he didn't get the prompt "xxx.xls is locked for
editing by 'user'"

I have recorded an excel Macro.  I am trying to paste a function down
for as many rows that are in my file.  However, as shown in the
following code, it is making reference to cell C2926, which happens to
be the last row in the file that I used to record the macro.  It causes

How do I protect certain ranges in a worksheet
--
colinfraser@prosealuk.co
-----------------------------------------------------------------------

I'm a bus driver. I want to keep track of my hours, and minutes for my own
records, in Excel. Here is an example...
Monday;  5:55am - 9:00am & 2:33pm - 5:33pm = 3hrs, 5min. + 3hrs, 0min. =
6hrs,5min.

I am using Excel for inputting data as part of a larger application. Each
worksheet roughly corresponds to a table for user input. Each table has a
predefined number of columns, the rest of the columns in the worksheet are
not being used and can be hidden from the user. My concern ...

using 2003
I have a shared workbook.  I want to use conditional formatting to color the
cell background if the cells has been updated.  How can I do that?
Glen

Try to type ~ in a cell or a string containing ~ and look for its full
content with the find and replace command.
Why doesn'it find anything ???
It is the same with the vba function.