I have a bunch of formulas in Column D.  All these formulas are incorrectly
written, so I would like to remedy that by pre-pending/appending two text
strings to them; this would create new, correct formulas in the process.
For the sake of simplicity, let's assume that in Cell D1 I ...

Is there a simple formula or function to count the number of characters and spaces in a cell
TIA
Mike K

I'm using a simple formula to count blank cells:
=COUNTIF(A2:F2,"")
Is there a way to exclude cells that are shaded within a formula?
Thanks,

I'm struggling to figure this one out. I have a date column and I'd like to
be able to calculate the age without doing it in my head.
I've tried to do this but am struggling.
Any help will greatly appreciated.

I want to use the conditional formating of a certain range of cells so that:
if a cell in that range is empty (nothing is shown) hide the entire row.
note: the values in the cells are copied from other cells in a different
worksheet.

I running Excel 2007 on a Win/XP Pro SP2 workstation.  I have a
spreadsheet I have been using for quite some time.  Its saved as a
'xls' file, not 'xlsx'.
Periodically, I add more data into one of the sheets - I have about 8

Good morning All,
I have an exploded doughnut graphic that I want to intersect with a
value -from another calculation- overlapping it to analogically identify one
of the values on the doughnut; sort of a "clock" graphic from one static and

How could I have an Excel file not open after a set date?  The people
that would use the Excel file are not the sharpest tools in the
drawer, so I was looking to have the file not open after a specific
date I could set.  

In which fonts do the letters take up the same amount of space?

I'm using ODBC to access the content of XLS files.
I see that the "table" names are in mainly in the form ...
worksheet$
'work sheet$'

Whatever I try, I am unable to open the data source.

Assume contest list with varying contestants. Now however they fall
into their places, the ranks will be have 35 places total. There are
more contestants, but we are only concerned with the final 35.
To kind of flip it around:

How do I protect a workbook having a number of sheets (around 50) allowing
the user to add a comment. I tried this with the following macro:
Sub Protect()
Dim ws As Worksheet

the text is seperated by "_", like("abc_xyz_spq") and is not set how
many "_"s there("abc_xyz_spq","xyz_spq","abc_xyz_spq_pqr" etc).
I want to do something to each text(abc,xyz,spq, etc).
How can I split them without VBA.

I have the following cells:
Country   Code   Rate   Carrier
Albania    355     .10     abc
Albania    355     .12     xbc