I WANT LIMIT THE QUANTITY OF LETTERS IN A CELL, HOW CAN I DO THIS?

I have 3 sumproducts that I am adding together and I would like to
combine them to one formula. Any suggestions?
Here are the current formulae:
SUMPRODUCT(--(VALUE(RIGHT(PosDeptNum,2))=$A7),--(PosStart<=G$6),--(PosEnd>=H$6),PosHrs/40)

I'm in over my head.  Any help would be appreciated.  
I have a workbook with 11 worksheets.  I need to look for a value in column
A within the first 10 worksheets and return the corresponding value from
column F to worksheet number 11.   Column A contains both text and numbers.  

I would be very grateful for your help with this.
I have several columns of data that I would like to line up and match
All the data is paired, each entry has a number from 1 to 130 and the
an attached value. The data in the common column is sorted numericall

How to convert #s to text. (for check printing)
Example: 5,136.25 covert to
"Five Thousand, One Hundred, Thirty-six and 25/100"
etc

In one of the columns would like to enter a time of completion, and in the
same row but different column would like the answer yes or no. yes if the
time is entered no if no time is entered would also like this collumne to add
up the yes and no's and give a total for each. Can ...

I am trying to us the Conditional Sum Wizard, but I keep getting the
following error message: Run Time Error '1004': Unable to set the
FormulaArray property of the Range class. What is it that I need to do to fix
this problem. I have used the Conditional Sum Wizard many times in ...

Cell A1 contains list created by choosing Data, Validation list and
specifying a named range for countries. Works fine.
Cell B1 must return a list or Order Numbers from the country choice in cell
A1. The Order Numbers are in a named range, that begins at cell D7 in another

I'm looking for a bit of advice.......
Can anybody explain the difference between 'saving as a web page' and
'publishing a worksheet'?
The reason I am asking - I am an IT Trainer and these two topics now have to

I tried in your office site for a keyboard shortcut for fill color/cell
shading in excel.If it is there please tellme.Otherwise please ad it to your
excel features
Jerry

Can anybody help?
I want to sit the MOS Exam for Excel 2003, however, one of the topics
covered on the exam is using XML.  I have never used this facility, nor seen
it working.  Does anybody know if any good websites that would explain what

I would like to set up a worksheet that will calculate based on the
following scale.
if an amount was in a specific range than the corisponding multiplier
would be used.

I am using Excel 2000 and wonder if there is a work-around for Rows to
Repeat at Bottom after each page break. You see, I have created a table which
requires insertion of new rows and its too troublesome  each time to redo the
borderline for end of each page. Thanks.

i m trying to do a commission statement for an agent and following ar
the criterias based on profit margin:
Profit Margin upto 20% - 1% commission
Profit Margin from 21% to 30$ - 2% commission

Each row from 2 on contains a product item in colum A. The top row, colums C
on, contain product options, >>30. Below that, each row has place to select
the product option (y/n). Column B must get all the options selected as a
concatenated text string. concatenate(if(c2="y",c$1 ...