Is there a function that will allows text and a formulas to be in the same cell? For example: susielh's commission this month is: D1*D2
All the example in the same cell showing the calculation?

How can I reference a file using a relative address?
If I have my spreadsheet in TopFolder on Drive C and the file that I
want to access in LowerFolder beneath, the following absolute reference
works:

I am having a terrible time getting my head around all the ins and outs of
using the IF and VLOOKUP functions.  Does anyone know of any helpful
webpages (especially if it is good for dummies) that I could view?
Thanks,

I was poking around this forum to try and find an answer to this but was
unable, and in the process, I found not many people seem to know about
this so here is a solution and a problem all at the same time.
I have seen a number of references on the board that said you can only

Does anyone know how I can get the cursor to return from
a column in the middle of a page back to the first column
when I hit enter? it now just drops down one box. The
tools - options way only changes direction to the

I am extracting data from a Remedy database and one of the fields is a date
expressed in seconds since 12:00 am, Jan1 1970 (approximately 1040688000).
Does anyone know if there is a way to convert these numbers to "regular"
dates?

Any idea how to delete an inserted picture in Excel in VBA:
(There is probably a really simple solution to my days of frustration
with this, but at this point it's a downward spiral)
If a picture is aleady on a worksheet, how can I select this and delete

I created a spreadsheet in ExcelXP but when I put it on our work pc with
XL97 protected cells can be selected. Is there a way to correct  this other
then upgrade XL?
Thanks a million in advance.

Is there a way to cut and paste all data from excel to labels in word. I'm cutting and pasting each cell one by one for now....

How would I create a spreadsheet that would indicate what type Product
is when a model # is put in multiple cells?
Here is my situation, I'm in the HVAC business and would like to be
able to put individual letters, (or numbers) in cells A1 through A20 or

I bring in a text file to Excel and we have Sectors
(example: North, South, Central, West, Hermitage) and I
have columns of citations and stops on each Sector and
then I generate a report of numbers for Sectors.   My

I have a value in Cell 1 that I need to check in numerous
ways (including against another cell) and then have some
text displayed.
If the value in Cell 1 is >=.2 or Cell2 = "YES" then Cell

Can anyone please help with a formula that I can't get to work, assuming it
is possible.
What I am trying to do is create a sheet so when interviewing school leavers
their qualifications can be entered and the sheet provides quick answers as

Here is some sample data:
22-Nov    36.5
23-Nov    28.2
24-Nov    29.2

Period Start (A5)    12/1/03 7:0
Job Start    (A6)    12/1/03 9:0
Job End        (A7)     12/24/03 6:5
Period End   (A8)       1/1/04 6:5