I'm using Excel 2003 and have setup a list of data and named it.  When I try
to setup the drop-down list feature and select data validation and select
"List".  The list is in a different workbook so I enter the name i have
defined preceded with an equal sign.  I get an error ...

I am using the CONCATENATE() function to combine two strings.  For example,
"seek " is in A1 and "help" is in A2 and =CONCATENATE(A1,A2) returns "seek
help".  The concatenation loses the formatting of the original words.  For
example, if "help" is bold, the concatenated phrase ...

I want to be able to have multiple columns in the first two rows of my
worksheet and then have a different amount of columns on the other rows.  I
would like to do this without merging the cells.  Any suggestions?

I need a macro or function to count the number of unique phrases in a word
table or spreadsheet. I have tried using several different COUNTIF functions
but I keep getting the same errors each time. Any suggestions?    

I am using excel 2003 and have created a small table, 4 colums wide by
5 rows.
I have inserted this table as an object into a Microsoft word 2003
document.

I'm trying to write a formula that will predict any number along a curve if I
provide the x coordinate.  Specifically, I'm a salesman and I have a product
that is less expensive the more you buy.  in other words, the price per unit
becomes flatter in higher quantities, but is ...

My users are copy/pasting from cell to cell.  This is fouling my data
validation. Is there any way to protect he DV and still allow copy/paste?
Thanks

I need to select certain lines from multiple worksheets (based on a field
value) and create a new worksheet containing all the lines. Any help would be
appreciated.

I have a 6 digit number in a cell.  I want the first 3 digits of it to appear
in another cell.  What is the formula?

The following are a few of generally accepted values:
% of Population    Number of Standard Deviations away from Mean
    50.0%                       0.674
    68.3%                       1.000

I'm trying to use Excel to generate a simple script text file but can't seem
to get it right. The file follows a fixed repeating pattern like the one
shown below and I'm trying to get Excel to insert a line from a list (A1, A2,
A3 etc) in the third line of the repeating pattern.

I need to hide a row if the date is filled in column H.  I understand you
cant do that with a formula and I am not familar with Macro.  Can someone
help with step by step directions????

Can you lookup based on a row number.
ie the data i want to lookup is in colum G in row 2003
This possible?
Thank

Is there a way I can combine data from the same column?  I know how to
concatenate, but that only seems to work between columns.  I would, ideally,
like to run the following: =J2&" "&J3.....
Is there a function in Excel or in VBA which can do this?

sdata validation lists should have the option to select different list
depending on selectable criteria. this greatly enhances data validation input
without having too long list
----------------