Howdy all.
OS: XP,   Excel 2002 SP3
I have my music stored in the My Music directory. I have Artist, Album
Title, etc. attributes turned on. What I'd like to do is to take all of this

Can we protact two or more sheets simultaneously using one password.
Similarly can we unprotect two or more sheets in single command having one
password.

Is there no function (Excel 2002) to return the Text() of another cell, as
it is displayed?
For example, if I had a formula =DisplayedText(Data!A1), I would want it to
return:

Client is using WinXP/Office 2003.
He has cells with Canadian postal codes. The postal codes should be 6
characters starting with a letter and then alternating every other with a
number. For example, V2L3M4. He would like a formula to evaluate the cell to

I'm writing a subsitute formula and want to replace %20 with "
but when I write =SUBSTITUTE(D3,"%20",""") I get an error and Excel makes me
do =SUBSTITUTE(D3,"%20","""")
Any way around this??

How can I calculate descriptive statistics for the following frequency
distribution?
Age Group    Frequency
15-20    59

I have a spreadsheet whereby i calculate whether the employee has worked
Dayshift (D) or Twilight Shift (T), based on the times. However sometimes the
empoloyees type in FL or F1 (for Flexi-time) and i need to change either of
these into D. I understand it is using the IF ...

Hi i am really having trouble to make the following work:
=IF(OR($F$9>28,$F$9<5),4,IF(OR($F$9>4,$F$9<13),12,IF(.....),20,0)))
Basically what i am trying to do is to find if F9 is between 29 and 4 then
return 4, if F9 is between 5 & 12 return 12, if it is between 13 & 20 return

I have written an indirect function in a cell which looks up to a worksheet
naming "C01_XXX_YYY", but it didn't work.  My colleague says INDIRECT does
not work with worksheets starting with the letter "C".  Is this true and how
do I overcome this problem?

Trying to format cells with conditions to show values; LOW, VERY LOW, etc.
Thanks.
CNS

I have a worksheet created and need a little help with how to find man hours
per case load onto the truck.  Have total cases per night and start and stop
time of workers.

need help with a worksheet and how to figure man hours per case.

How do I format cells in a spreadsheet to not show a zero balance as being
negative, i.e (0.00)?  This does not happen in all of the cells only some?

In Excel, how do I sent a page from a workbook via e-mail to several addresses?
In Excel, how do I set the Enter key to move to the right, not down.
Thanks,
Art

Here are the formulas I am trying to put together into one formula but cannot
seem to get it right.
IF((AND($I$5="",$J$5="")  IF TRUE THEN DO THE FOLLOWING CALCULATION:
SEE IF ONE OF THE FOLLOWING APPLY: