I wish to search a block of text in a cell for any strings of text
within double quotation marks and put this string in a new column. If
there are more than one set of quotation marks then the subsequent
strings should be put in the next row. Is this possible?

Situation...
In one column of a workbook there is text that cell by cell may or may
not contain a date.  I want to extract the sate (if one exists) and
store it in the next column.

Is it possible to change the lettertype of the rowheadings (1, 2, ...) and
the columnheadings (A, B, ...)?
And to change their alignment, for example left alligned for the
columnheading?

Why does excel automatically change my symbor "IHS" to "HIS"?  Just lost a
big time with one of my clients due to this error.  Is there a way to turn it
off?

New at this hope this makes sense:
I have rows of data that include entering demographics, 6 columns indicate
race, 2 columns gender, six age range columns and a total participant column.
What formula would add the numbers in each of the demographics and insure

ok, I have a list of transactions by day, like so:
     01/07/2007  £   13.99
     01/07/2007  £   92.46
     03/07/2007  £   56.94

When I open a document created in a previous version of Excel (*.xls) in
Excel 2007 and then save it to a DIFFERENT location, the "Date Modified"
property in Windows of the ORIGINAL file is changed.  
Why does this happen?  I haven't changed the original file.  Is there any

I have a big problem, but I don't known how excel can solve it.
I have a sheet with like it:
process       process_line    status    values_USD
0255155           10                 44               10

I have a list of 32 numbers some of which should roughly add up to a
given value, when i say roughly i mean +/- 10.000. Is there any way to
set solver to do this or does it need some VBA (not a problem, just
point me in the right direction) solution?

Is there a way I can reference a checkbox item that I can manipulate
in VBA.
For instance...
I have a series of check boxes that I would like to change the

Ok, I thought this would be easy enough but the answer keep avoiding me.
I work in a small rural clinic and we get a lot of sample medications that
we provide to folks that cannot afford medicines.  For about 3 years now I
have watched managment mismanage this inventory.  Paper ...

Two computers:
Computer1 (desktop):
Pentium D - dual core, 3.2 GHz
2 GB Memory

I have a problem with Excel 2002 SP3. Everytime I open excel and I close it
later on. The window closes but not the process. So, If I open 10 times
excel in a day I will have 10 process in my Windows Task Manager and I have
to close them manually. Could someone please help me ...

I downloaded a Bi-weekly timesheet for Excel.  The timesheet is perfect
except for the date part.  The time sheet comes with a Monday to Friday
bi-weekly time set-up and I need to change it to a Thursday to Wednesday
bi-weekly time set-up.  At present I had to individually change ...

I have a macro with the following code
range("h5").value=application.sum(range("a2:f3"))
If a value in the range A2:F3 is cahnged I need to run the macro again so as
to change the value in cell H5.