I have names and addresses in a workbook that are all in separate cells. One
cell has first name, the next cell has last name. I want to combine those
two into one cell. How do I do it?
Thank you,

I'm trying to create a keyboard shortcut, but when I go into the "commands"
tab "modify selection" is dimmed out.

Whenever I open a document in MS Excel 97 or in MS Word 97, I get this
strange message:
"A document with the name [insert name here] is already open. You cannot
open two documents with the same name, even if the documents are in

I'm writing an application that exports calculation results into files.
From within my program, I can launch Excel and load that file by passing
its name as a command line argument.
Does anyone know how I can also launch a macro or an add-in through

I use excel spreadsheets for cost reporting.  I have  a summary page an
35 separate schedule pages.  the schedules have columns showing cost t
date, cost to complete, budget, over/under spend etc.  the totals ar
linked back to the summary page.  the summary page shows these total

I am trying to create a  financial year workbook April 04 March 05 with
fixed headings ie date, item, etc etc across the top set at the spacings I
require. I have created the first worksheet and named it April 2004, how do
I then copy these settings into the next 11 worksheets ...

Is there a way to have text or background blink (like in Word)?

Would someone be kind enough to help me on this? I want to take a list
compare it to a table, and if a match copy all of the elements from th
table in the same row in which the element match was found:
LIST

In Excel 97, how can I arrange it so that If C30>D30,color
= green?
Thanks,

   I use Office 2002 with Windows 2000 and I would like to use the format
(500.00) when it is negative instead of  the minus sign when writing numbers
I do not have that option in the format cell, how come?
My friend is using the same Office 2002 with Windows 2000 and she does have

I have a certain cells in a row set up to word wrap but I am uncertain how
to make the row automatically widen to show the entire contents of the
cells.  It will grow (up and down) but not enough for all text.
Any suggestions?

Sheet1!C4 contains the formula =Sheet2!A1
I want Sheet1!D4 to find out what cell Sheet1!C4 is referencing an
then return the value two columns over.  (Offset will take care o
returning the value two columns over).  My problem is I need to kno

I would like to create a function or macro to automatically enter th
date when a number in an adjacent cell is entered.
I am new to VBA and haven't been able to figure this out yet.  An
ideas?  TH

Please Help
I am building a Time Sheet in excel 2000.
I have 4 cells.
1. In

I have figured out the first part of this problem, but can't seem to ge
any farther.   Here's what I need
Basic synopsis:  each client has a different percentage to which thei
invoices are multiplied, i.e., Column A is the client name, Column B i