I have the following in col A:
RMMX003245
TFM127854
I want cols B and C to contain the split info from col A:

I have a sheet that has a title and header cells as 2 rows frozen at the
top.
I would like those two rows to appear on every printed page.
Is this possible?

I'd like to copy a tab to a new tab, and then have it read information
from the previous tab.  Example:  ='4'!B112   Where on tab 5 it is
reading from tab 4, cell B112.    I'd like to change the 4 to be "the
page before" so I don't have to change the 4 to 5 and 6, .... on every

I have both excel 2003 and excel 2007 which is part of MS office enterprise
2007 installed on my computer. I was told that the new excel 2007 can support
column limit 16,384. but I found it still has only 256 column, does someone
knows why?

I want to store installment details of employees in the format: 9/15,
10/15 etc.. These are text values and are transferred via .NET
application to Excel. But it considers it a date and so converts 9/15
to 15-Sep, 10/15 to 15-Oct. I even searched for options to disable

I'm using this formula
=100*SUM(D11:F11)/SUM(D11:K11)
but if none of the cells in the range have any data, the result is #DIV/0!
I'd like to add to the formula that if nothing is entered to return blank. I

When clicking on the format cell option on one of our computers, it
immediately closes Excel out with an error stating that excel.exe has
generated errors and had to be closed.  It doesn't matter if you do it from
the top menu or if you right click on the mouse.  We have tried ...

Hi, I have a section of a worksheet that just needs to show working days
between two dates.
For example, an order was entered on 9/2/07 and complete on 9/15/07
The formula    =NETWORKDAYS(A1, A9) works perfectly except that until the

For reasons unknown (possibly an automatic background update) the
toolbars in Excel 2003 went walkabout.  Have restored the Standard and
Formatting toolbars but the area which used to include the active cell
by name or reference (far left), the "Fx" function icon and the content

Is it possible to make a link from a cell to an image so that it would not
open in a new window, but would show as a pop up?
Thanks
Kalevi

I have a workbook file with multiple spreadsheets. When selecting more than
one at a time, the tabs all stay white so I can't tell which ones are
included in the group mode and which aren't.  How can I get the selected
sheet tabs to display in a different color so I know which ...

Excel 2002 SP3
Win XP HE
Hi,
1) In cell B3 I have a beginning date.  In B4, an ending date.

I'm trying to use some event code kindly provided by Bob Phillips in message
news:u$MX4fVxHHA.312@TK2MSFTNGP04.phx.gbl... (13/07/2007) that alternately
puts and removes a tick in each cell of a range of cells.
Bob wrote:

Not sure if this is possible in Excel.
I am using Excel 2003 SP2 at work. In a column, I have a formula that is
copied down the column so that if a condition is valid, it prints a "Y",
otherwise nothing:

I have a workbook with multiple worksheets that are all identicable.
However, in each worksheet I have created a drop down data validation combo
box for the same specific cell in each worksheet.  The data for the drop down
list is set once and every time I select from the drop ...