I know that Alt-Enter inserts a carriage return in a cell, however, I need to
do this programatically, gathering text from cell one, inserting the carriage
return, then text from cell 2.
Cell A1 contains the text "LINE ONE "

I am working on a financial monthly report for my company and am having a
difficult time with a graph.  On the customer complaints graph  months Jan.
thru April 2006 do not come out correctly and I have no clue why.  I have
tried everything I can think of and am completely ...

I am trying to extract certain information from multiple workbooks into one
workbook sheet.  The data I am wanting to compile varies between workbooks
with respect to the row and column addresses.  In otherwords, it isn't in the
same location everytime.  Most of the data is ...

Can I pull data from one sheet to another (summary) because of color?
I have conditional formating that shows me on one sheet what groups are
late, now on the summary sheet I want to pull a result list of just the group
names if the group name cell has turned yellow.

Having problems with this one.
Column B has sequential dates entered. I would like to find out how many are
today's date so I tried this:
COUNTIF(b5:b100,=now())

One of our databases churns out a 5 digit date such as 10410 is
October 2004.  The 1st 3 characters indicate the year (e.g., 107 is
2007, 106 is 2006, etc) and the last 2 characters indicate the month.
Is there a custom date format that would make it easier to read, and

I have in cell A25 the text "-   6/19/2007  6:22:12 PM".  The formula
   =DATEVALUE((TRIM(MID(A25,FIND("-",A25)+3,11))))
is giving me a #VALUE! error.
How can I get it to return the correct date?

I CANNOT GET MY GRIDLINES TO SHOW ON EXCEL EVER THOUGH I WENT TO PAGE SETUP
AND CHECKED GRID BOX, WHATS WRONG?

The following function returns formula as a string, does anyone have any
suggestions on how to retrieve the value from formula and store into x and y
variable?
Working with an opened file under E:\dir\file.xls, I try to compare the

I'm trying to use a SUMIF function on a column that includes SUBTOTAL
functions. The SUMIF seems to include the SUBTOTAL even though it doesn't
match the criteria. Why? How can I can exclude the SUBTOTALs from the SUMIF?
TIA, Graeme

Hi
I need some solutions to the following.  Please help.
Original
             Supplier 1    Supplier 2     Supplier 3 .......

We are trying to do a simple <=PRODUCT> function where we multiply two cells:
the first cell is a number generated by an <=IF> function, and the second is
simply a cell with a single digit number.  The result only shows the single
digit number, viz 4*3=3.  Any ideas?

I was wondering how one could remove the add-ins tab from 2007. I have a
couple of dead buttons and I want to use a new version of the toolbar it
represents (from 2003)
Any ideas?

I need to create a unique data from a spreadsheet with the design as below:
       1/1/07    2/1/07     3/1/07 ...... (date at row 1)
9am      abc      xyz       (empty)
11am    rst       abc          xyz

Right, ignore my last re counting date entries that are the same, I have
managed to do it! Except fot the MIN bit.
Is there a way to adapt MIN so that it will ignore 0 values in a list?